🚀 go-pugleaf

- Use server-side cursor for this procedure. This way you will not cache all 
your rows in memory.

- Use fields variables:

TField* fBid = CountQuery->FieldByName ("bid");
..

while ...
  v_time.push_back(fBid->AsDateTime);
...

How much time takes line CountQuery->Open(), and how much - while loop?

//------------------------------------------
Regards,
Vassiliev V. V.
http://www.managed-vcl.com - using .Net objects in Delphi for Win32 +
ADO.Net
http://www.oledbdirect.com - The fastest way to access MS SQL Server,
MS Jet (Access) and Interbase (through OLEDB)


"Cenk" <cenk1536@yahoo.com> �������/�������� � �������� ���������: 
news:44d8a854@newsgroups.borland.com...
> Hi,
>
> i have a code sample below,
>
> TADODataSet *CountQuery = new TADODataSet(this);
>  CountQuery->ConnectionString = "Provider=SQLOLEDB.1;Integrated 
> Security=SSPI;Persist Security Info=False;Initial Catalog=Raw;Data 
> Source=CENK";
>  CountQuery->CommandTimeout = 0;
>
>
>  if  (CountQuery->Active)
>     CountQuery->Close ();
>
>
> CountQuery->CommandText = "select [bid],[fTime] from ["+table+"] order by 
> [fTime] ASC";
> CountQuery->Open ();
>
>  while (!CountQuery->Eof) -------> table has 1000000 rows of data inside 
> but this loop takes appox. 45 minutes to complete!
>  {
>
>     v_bid.push_back(CountQuery->FieldByName ("bid")->AsFloat);
>
>           v_time.push_back(CountQuery->FieldByName ("fTime")->AsDateTime);
>
>           CountQuery->Next ();
>        }
>
> why is this too slow? any suggestions?
> thanks
>