tClientDataset too slow

Thread View: borland.public.cppbuilder.database.multi-tier

1 messages

[T] Back to Threads [V] Tree View [G] Group Articles

1 total messages Started by Carlos Hern�ndez Fri, 09 May 2003 16:19

#183

Author: Carlos Hern�ndez
Date: Fri, 09 May 2003 16:19

22 lines
1435 bytes

If I use a TTable (BDE) to update all the records in a paradox table with
100,000 records, using:

  while( !ClienteActas->Eof )
  { ClienteActas->Edit();
   ClienteActas->Fields->FieldByName("folio")->AsString = "";
    ClienteActas->Post();
    ClienteActas->Next();
  }

it take just a few seconds ( less than 10 seconds)  Here, ClienteActas is a
TTable.




But if I do the same with a ClientDataSet,  (Here, ClienteActas is a
ClientDataSet) it takes more than one hour or gives an out of memory error.

How can I do it more efficient?

Thank you

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads