Subject | insert in Firebird |
---|---|
Author | C R Zamana |
Post date | 2001-08-28T18:19:18Z |
Hi fellows!
I have an application written in FlagShip ( shortly: xbase/clipper for
Unix ).
This application is compiled to access Oracle ( 8.1.7 )
and Firebird( 1.0.0-0aBeta2 ).
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.
Strange, huh?
Is there any thing that I'm missing here? Is there any
fine tunning that I can make in Firebird in order to have
my insert less slow?
The system/machine is:
Linux ( RedHat 6.2, with many updates )
Kernel: 2.4.8
CPU: AMD Athlon 1Ghz
RAM: 128M
HD: IDE
glibc-2.1
gcc egcs-2.91.66
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
------------------------------------------------------------------------
I have an application written in FlagShip ( shortly: xbase/clipper for
Unix ).
This application is compiled to access Oracle ( 8.1.7 )
and Firebird( 1.0.0-0aBeta2 ).
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.
Strange, huh?
Is there any thing that I'm missing here? Is there any
fine tunning that I can make in Firebird in order to have
my insert less slow?
The system/machine is:
Linux ( RedHat 6.2, with many updates )
Kernel: 2.4.8
CPU: AMD Athlon 1Ghz
RAM: 128M
HD: IDE
glibc-2.1
gcc egcs-2.91.66
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
------------------------------------------------------------------------