I've runned your test: 3304 ms (7200 rpm hard disk, pentium3 1Ghz).
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
Out application with pgsql (but I think the problem is zeoslib) is a
little slower than ms-access ! We have good results with MySQL and
Firebird (using zeoslib).
access ? really ?
what is the size of your dataset ?
i've seen an access application literally die, belly-up with like 15
minutes
In our testing Postgres came out on top, well MySql was faster if you
use the non-transactional table type "MyISAM". If you use the InnoDb
table type it comes out slower. All of this is very subjective depending
on your querys and data set. Have you run the ANALYZE command on
Postgres since you
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
On 11 Jan 2005 at 8:16, lol wrote:
> 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.
I've recently started using dbExpress with Delphi 6 for a desktop
client application, and have found it fast and easy
What queries are you running?
What sort of a machine are the database systems running on?
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of lol
Sent: Tuesday, January 11, 2005 6:47 AM
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] PostgreSQL 8 on
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)-
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
lol wrote:
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
what zeoslib do you use?
6.X?
thay are
Daniel Schuchardt wrote:
lol wrote:
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
lol wrote:
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
adj
11 matches
Mail list logo
