🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: borland.public.cppbuilder.database.ado
Article #2065

Re: Performance problems when insertings data in a Access-DB

#2065
From: Palmetzhofer Dietmar
Date: Sun, 30 Nov 2003 17:12
46 lines
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-mail
References: <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