Article View: borland.public.cppbuilder.database.ado
Article #2065Re: Performance problems when insertings data in a Access-DB
From: Palmetzhofer Dietmar
Date: Sun, 30 Nov 2003 17:12
Date: Sun, 30 Nov 2003 17:12
46 lines
2910 bytes
2910 bytes
This really speeds up my application. But I encountered another problem now: When I am trying to insert a record in a detail-table (from a master/detail relationship), I get the error: "<Fieldname> can not be changed. Is it not possible to use master/detail-relationships when using ServerSide cursor? Thanks, Didi "Viatcheslav V. Vassiliev" <support@oledbdirect.com> schrieb im Newsbeitrag news:3fc9b250@newsgroups.borland.com... > Use server-side cursor - CursorLocation = clUseServer and TableDirect = > true. Call DisableControls()\EnableControls() even if you have no controls > attached. If you need extreme speed, try OLEDB Direct at > http://www.oledbdirect.com > > file://------------------------------------------ > Regards, > Vassiliev V. V. > http://www.managed-vcl.com - using .Net objects in Delphi + ADO.Net > http://www.oledbdirect.com - The fastest way to access MS SQL Server, > MS Jet (Access) and Interbase (through OLEDB) > > "Palmetzhofer Dietmar" <dietmar.palmetzhofer@boku.ac.at> �������/�������� � > �������� ���������: news:3fc8a70e@newsgroups.borland.com... > > I have to insert (or update) lots of datasets in a Access-2000 DB, and > this > > takes a LOT of time. I am doing this by using > > TTable1->Append(); > > // set the fieldvalues > > TTable1->Post(); > > in a loop. Does anyone know if there is a possibility to use a batch-job > for > > this (i.e. inserting the records in a buffer and posting them in one > step)? > > > > Can somebody explain to me, what the different Execute-Options mean? The > > explanation in the helpfile is not very helpfull for me ... > > > > Thank, > > Didi > > > > > > >
Technical Details
Message-ID:
<3fca2387@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!news.maxwell.syr.edu!newsfeed.icl.net!newsfeed.fjserv.net!news.tele.dk!news.tele.dk!small.news.tele.dk!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mailReferences:
<3fc8a70e@newsgroups.borland.com> <3fc9b250@newsgroups.borland.com>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII X-Google-Thread: 10698b,debaddcdb1259366 X-Google-Attributes: gid10698b,public X-Google-ArrivalTime: 2003-11-30 09:09:07 PST Reply-To: "Palmetzhofer Dietmar" <dietmar.palmetzhofer@boku.ac.at> From: "Palmetzhofer Dietmar" <dietmar.palmetzhofer@boku.ac.at> Newsgroups: borland.public.cppbuilder.database.ado References: <3fc8a70e@newsgroups.borland.com> <3fc9b250@newsgroups.borland.com> Subject: Re: Performance problems when insertings data in a Access-DB Date: Sun, 30 Nov 2003 18:12:07 +0100 Lines: 48 Organization: Univ. f. Bodenkultur X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 5.50.4522.1200 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200 NNTP-Posting-Host: 62.46.226.139 Message-ID: <3fca2387@newsgroups.borland.com> X-Trace: newsgroups.borland.com 1070211975 62.46.226.139 (30 Nov 2003 09:06:15 -0700) Path: arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!news.maxwell.syr.edu!newsfeed.icl.net!newsfeed.fjserv.net!news.tele.dk!news.tele.dk!small.news.tele.dk!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail