Subject | RE: [ib-support] insert in Firebird |
---|---|
Author | Leyne, Sean |
Post date | 2001-08-28T18:27:26Z |
> On the same machine the task ( batch process, mainlyHow often are you committing the changes?
> 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 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