Re: TADOQuery slow inserts in Oracle

From: Viatcheslav V. Vassiliev (support_at_oledbdirect.com)
Date: 07/20/04 

Date: Tue, 20 Jul 2004 11:05:36 +0400

Use server-side cursor - you do not need row cache if you do only inserts on
this dataset. Call DisableControls()/EnableControls() even if you have no
controls attached.

Or, even better, use prepared ADO command with parameters.

//------------------------------------------
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)

"Bryce K. Nielsen" <bryce@sysonyx.com> сообщил/сообщила в новостях
следующее: news:40fc2d4a$1@newsgroups.borland.com...
> I've used ADO before with Oracle, but never had such slow effects as I'm
> having now. I'm opening a TAdoQuery, calling .Insert, setting a bunch of
> FieldByNames, then calling .Post. It's the .Post that takes about 2 or 3
> seconds, and it's killing my application, a simple data-transfer app
between
> MS SQL and Oracle. What can I do with my TADOQuery to speed up the .Post?
Am
> I overlooking a property?
>
> Thanks,
>
> -BKN
>
>

Relevant Pages