tClientDataset too slow

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

Article #183

Back to borland.public.cppbuilder.database.multi-tier Previous Next

#183

From: 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

Technical Details

Message-ID: <3ebbd4c9$1@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-03!sn-xit-01!sn-xit-08!supernews.com!newsfeed.wirehub.nl!news.kweb.on.ca!KWeb!newsgroups.borland.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: fcd2b,b4f35851dfa6cb95,start
X-Google-Attributes: gidfcd2b,public
X-Google-ArrivalTime: 2003-05-09 09:26:07 PST
From: "Carlos Hern�ndez" <carlosh@servidor.unam.mx>
Newsgroups: borland.public.cppbuilder.database.multi-tier
Subject: tClientDataset too slow
Date: Fri, 9 May 2003 11:19:48 -0500
Lines: 24
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2720.3000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
NNTP-Posting-Host: 132.248.17.31
Message-ID: <3ebbd4c9$1@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1052497097 132.248.17.31 (9 May 2003 09:18:17 -0700)
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-03!sn-xit-01!sn-xit-08!supernews.com!newsfeed.wirehub.nl!news.kweb.on.ca!KWeb!newsgroups.borland.com!not-for-mail