Search results for query: *

Hi There, Ok... I give up!! Whats required to setup a distributed join functionality between Aix udb 7.1 on two different servers? For example: select x.col1, y.col1 from table x, <----- Aix Server a / Instance aa table y <----- Aix Server b / Instance bb I initially thought...

avivit, Rowsize or average rowsize for all rows in a table can have huge impact on overall database performance. I can't give you definitive answer as related to Access but I can give you some observations and guidelines that apply to RDBMS's in general. 1. You need to know the average...

Hi avivit, Good points, I guess I wasn't too clear on my definitions. Perhaps this redefinition will help :-) 1. The reference to 500k rows is the number of rows in the in the database, not the length of each row. 2. By 'choke' I mean Access may abort or hang. In either case it would...

MS Access db isn't in the same league as Oracle! It's been my experience the Access chokes at around 500k rows. By comparision, I've worked on numerous Oracle databases in the 100 million row range with a size of 1 terabyte and up. I'm currently getting ready to deploy a dot.com Oracle...