Hi,

At May 22, 2003, 16:14, Erik S. LaBianca wrote:

> I wondering if any of you have had any luck speeding up inserts to
> interbase? I've found that using both DBD::InterBase and IBX under
> delphi insert operations are quite slow. I've tried playing with my
> transaction component settings in delphi to no avail.

> Is using an external table the only way to get data in faster?

Use an insert statement with parameters, so you only have to prepare
once. If you prepare the insert statement everytime, that usually is
a performance penalty. IBX might prepare the statement, even if you
don't explicitly do.

--
Best regards,
Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.filopto.com)