I HAVE SOLVED THE PROBLEM, BECAUSE I DO NOT KNOW TO USE INDEX IBSERVER OFF
COURCE IS TOO SLOW, THERE FORE I AM USING INDEX, AND EVERY THING GOOD, BUT
THERE IS ANOTHER PROBLEM WITH EXTERNAL FILES, EXTERNAL FILE RECOGNISE THE
DATA IF THEY ARE IN THE SAME LENGTH, HOWEVER, FOR MY DATA IN A TXT FILE, THE
LENGTH OF THE DATA IS NOT EQUAL,

THE ONLY SOLUTION TO THIS PROBLEM SEEMS TO USE DELPHI, CODING, BUT IN THIS
CASE SINCE THERE WILL BE APPOXIMATLY 1.000.000 RECORD, I DO NOT KNOW HOT TO
INSERT MANIPULATED DATA INTO GDB, IS THERE ANOTHER DATABASE, MY BE PARADOX
THAT WILL SUPPORT AT LEAST 1.000.000 RECORD, EXCEL SUPPORT UP TO 65.500
RECORD, THERE FORE IT IS NOT SUFFICIENT.

THANKS TO EVERY BODY
KURSAT

-----Original Message-----
From: Ann W. Harrison [mailto:aharrison@...]
Sent: Thursday, December 13, 2001 5:53 PM
To: ib-support@yahoogroups.com; 'ib-support@yahoogroups.com'
Subject: RE: [ib-support] IBServer too slow wiht 600.000 record


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.