Ops. That uppercase was driving me crazy but... I will try to help.

Suggestion:

a) Create a Table that will old the copy of all info from the external file,
with all fields that you have needed from that external File;
b) In your delphi application, 'pump' all data to that table. You must start
by deleting all records (delete * from TableBlaBla), and dupping the values
from the external table to that table (I know you re using IBO, so take a
look at IB_Import component - it will do what you want to do, even with
non-fixed len fields in your external table).
c) Once you have your data in that table, you can use SQL to do whatever you
want.

I think your main problem will be solved with this, with little code. If I
have understood well, you don't want to simply import the data, but get some
statistics values first. This will help you, for shure.

In your case, forget the external File. You must take the suggestion in this
list as 'suggestions' and not 'rules'.

Artur Anjos

----- Original Message -----
From: "KURSAT TASKIN" <kursatt@...>
To: <ib-support@yahoogroups.com>
Sent: Thursday, December 13, 2001 4:10 PM
Subject: [ib-support] IBServer IS FAST, BUT EXTERNAL FILE PROPERY IS A
PROBLEM FOR ME AT THIS MOMENT!!!


> 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.
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>