Skip site navigation (1) Skip section navigation (2)

Re: [GENERAL] interesting PHP/MySQL thread

From: Sean Chittenden <sean(at)chittenden(dot)org>
To: nolan(at)celery(dot)tssi(dot)com
Cc: Jan Wieck <JanWieck(at)Yahoo(dot)com>,Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>,Josh Berkus <josh(at)agliodbs(dot)com>, Joe Conway <mail(at)joeconway(dot)com>,"\"Advocacy PostgreSQL\"" <pgsql-advocacy(at)postgresql(dot)org>,PostgreSQL-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: [GENERAL] interesting PHP/MySQL thread
Date: 2003-06-23 03:07:02
Message-ID: 20030623030702.GM97131@perrin.int.nxad.com (view raw or flat)
Thread:
Lists: pgsql-advocacypgsql-docspgsql-general
> I know it took me a while to convince the CIO on the project I'm working
> on that PostgreSQL was an improvement over MySQL.  He's slowly coming
> around as I start to show him what I am doing with the much richer 
> PostgreSQL feature set, but the performance of 7.3 compared to MySQL is 
> likely to remain a bit of a sticking point, because some queries are 
> taking 2-3 times as long on the same platform with the same data.
> 
> If the data entry folks, who are probably about to get a look at a portion 
> of the application that is still using the MySQL engine, get used to the 
> search times there, when we switch the whole thing over to PostgreSQL we 
> may get complaints if searches that used to take 3-4 seconds are now 
> taking 10-12 seconds.  (Have others noticed that 7 seconds seems to be 
> a threshold point for users reacting to query times?)

Whoa, something's not right.  Could you please send along an EXPLAIN
ANALYZE after doing a VACUUM ANALYZE of your query that's taking 3-4x
longer?  Something smells very strange here because my experience has
been quite the opposite...  I can understand 0.05ms longer per
connection in setup overhead (fork() vs new thread) , but this seems
like way too much... I wonder if you couldn't benefit from the use of
a cursor if you're returning a large dataset.  -sc

http://developer.postgresql.org/docs/postgres/sql-declare.html
http://developer.postgresql.org/docs/postgres/sql-fetch.html
http://developer.postgresql.org/docs/postgres/sql-close.html

-- 
Sean Chittenden

In response to

Responses

pgsql-docs by date

Next:From: Christopher Kings-LynneDate: 2003-06-23 03:09:23
Subject: Re: [GENERAL] interesting PHP/MySQL thread
Previous:From: The Hermit HackerDate: 2003-06-23 03:03:18
Subject: Re: [GENERAL] interesting PHP/MySQL thread

pgsql-advocacy by date

Next:From: Christopher Kings-LynneDate: 2003-06-23 03:09:23
Subject: Re: [GENERAL] interesting PHP/MySQL thread
Previous:From: The Hermit HackerDate: 2003-06-23 03:03:18
Subject: Re: [GENERAL] interesting PHP/MySQL thread

pgsql-general by date

Next:From: Christopher Kings-LynneDate: 2003-06-23 03:09:23
Subject: Re: [GENERAL] interesting PHP/MySQL thread
Previous:From: The Hermit HackerDate: 2003-06-23 03:03:18
Subject: Re: [GENERAL] interesting PHP/MySQL thread

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group