Subject RE: [ib-support] IBServer too slow wiht 600.000 record
Author Ann W. Harrison
At 04:18 PM 12/13/2001 +0200, KURSAT TASKIN wrote:

>I am reorganizing the database, tables, because there are apporoximately
>500.000 records that will enter the database. in my study, I am collecting
>the stock data from an external txt file, then I am copying the data to gdb,
>and getting the result max, min, avr of the prices.

1) AVR should be AVG
2) Take a look at external tables. They could help your load time.


Regards,

Ann
www.ibphoenix.com
We have answers.