Subject Re: [ib-support] insert in Firebird
Author C R Zamana
Leyne, Sean wrote:
>> 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?

After each insert.

> How many records are you processing?

Exactly 3813.

> 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?

I don't know how to check this. However a "show database"
give me the following:

Number of DB pages allocated: 4441
Sweep interval = 20000

Thank you.
Best regards.

zamana@... | "Emacs is a nice OS - but it lacks a good text
zamana@... | editor. That's why I'm using Vim. Anonymous |