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

API ( ESQL/C ).

>
> What indexes are defined for the table?

None.

>
> What is the database cache setting?

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

PAGE_SIZE 4096
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
http://www.inso.com.br | http://www.vim.org/quotes.html
------------------------------------------------------------------------