Hi,
I'm currently testing several databases for an application written in
Delphi 7. I use zeos lib to access PostreSQL8-RC1 on MS-Windows 2000
SP4. PostrgreSQL is extremly slow, with a lot of disk access on INSERT
request. Have-you seen this problem ? May be some parameters should be
adjusted. Wha
I use zeoslib 6.1.5 for Delphi 7. I have also tried 6.5.1-alpha. It's
faster (especially with firebird).
I will take a look at dbExpress.
Thank you.
---(end of broadcast)---
TIP 7: don't forget to increase your free space map settings
I have tried RC4, but there's no differences
My results using my configuration are :
MySQL 4 is 6 times faster than pgSQL
Firebird 1.5 is 3 times faster than pgSQL
Are these results coherent ? May be the problem comes more from ZeosLib
than pgSQL8
---(end of broadcast)-
Well, for SELECT request pgsql runs well, although it's a little
slower than firebird & MySQL.
The problem is especially for INSERT request. It's strange there's a
lot of disk access, as if it doesn't use the cache or something like
that (I'm not a db expert).
The application runs on windows 2000
I've runned your test: 3304 ms (7200 rpm hard disk, pentium3 1Ghz).
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
