🚀 go-pugleaf

"Star" <---> wrote in message
news:4106de81$1@newsgroups.borland.com...
> Hi,
>
> I have very big table (about 50 million records). I usually make
some
> queries on this table, and it can take
> several minutes to run. Is there anyway to start getting records as
soon as
> there is one available?
>
> I thought I could use something like this:
>
> ADODataSet1->CommandText = "SELECT Code From Subs_Subjects";
>
> ADODataSet1->ExecuteOptions = ADODataSet1->ExecuteOptions <<
eoAsyncFetch;
> ADODataSet1->Open();
>
> Is that the way to do it? Should I get an event for every new record
> returned? In that case, what event should I look at?
>
> Thanks

One thing that helps, for SQL Server anyway, is adding the phrase "
OPTION (FAST 50)" to the end of the SQL statement.  This indicates you
want rows returned quickly.  Another mechanism is to limit the number
of rows returned by setting the TADOQuery's MaxRecords property.

- Arnie