Neville,


nevillerichards schrieb:

> I am converting a large project from Paradox to IBO (using the TDataset equivalents).
>
> The software imports and processes large quantities of ASCII data.
>
> So far, the IBO version seems to run at about 1/5 the speed of the original Paradox. I am sure that this isn't how it was supposed to be!
>
> Does anyone know of any obvious pitfalls that people usually drop into?

Lots of.
The first one is: You can't compare Firebird / Interbase to Paradox in
_any_ respect.
Firebird is an SQL server, Paradox is a desktop database.

An SQL server is made for serving lots of users, keeping rules inside
itself so these have to be obeyed when inserting records.

I've got no idea about the Paradox speed with imports, so I don't know
what 1/5 of unknown is. ;-)

So the main question is: How are you importing data?
I'm quite sure you don't use sth. like prepared insert statements with
IB_DSQL, do you?

Please show us what you do, so we can tell you what you can do for
improving the insert speed.

Regards
Luc.