I update 10 million plus records daily - only effective method I have found
is stored procedures - any other method is just too slow

-----Original Message-----
From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com] On Behalf
Of kokok_kokok
Sent: 03 October 2007 13:17
To: IBObjects@yahoogroups.com
Subject: Re: [IBO] Optimize massive inserts with TClientDataSet + IBO

Yes, I use SP when I can, but in this case, I have the data in memory
for design questions, then I need to dump it from the TClientDataSet
to a database table.





___________________________________________________________________________
IB Objects - direct, complete, custom connectivity to Firebird or InterBase
without the need for BDE, ODBC or any other layer.
___________________________________________________________________________
http://www.ibobjects.com - your IBO community resource for Tech Info papers,
keyword-searchable FAQ, community code contributions and more !
Yahoo! Groups Links




No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.488 / Virus Database: 269.13.39/1045 - Release Date: 02/10/2007
18:43


No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.488 / Virus Database: 269.13.39/1045 - Release Date: 02/10/2007
18:43