Subject RE: [ib-support] insert in Firebird
Author Leyne, Sean
> On the same machine the task ( batch process, mainly
> insertion ) tooks
> about 22 minutes with Oracle. With Firebird it tooks between 4 and
> 5 hours to make only a half of the job.

How often are you committing the changes?

How many records are you processing?

What tools are you using to connect to the database? (i.e. ODBC, IBX,
IBO or API?)

What indexes are defined for the table?

What is the database cache setting?


Sean