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

Re: [GENERAL] interesting PHP/MySQL thread

From: nolan(at)celery(dot)tssi(dot)com
To: JanWieck(at)Yahoo(dot)com (Jan Wieck)
Cc: pgman(at)candle(dot)pha(dot)pa(dot)us (Bruce Momjian),josh(at)agliodbs(dot)com (Josh Berkus), mail(at)joeconway(dot)com (Joe Conway),pgsql-advocacy(at)postgresql(dot)org (\"Advocacy PostgreSQL\"),pgsql-general(at)postgresql(dot)org (PostgreSQL-general)
Subject: Re: [GENERAL] interesting PHP/MySQL thread
Date: 2003-06-23 02:54:39
Message-ID: 20030623025439.28324.qmail@celery.tssi.com (view raw or flat)
Thread:
Lists: pgsql-advocacypgsql-docspgsql-general
> To clearify, we need to encourage the PHP developer community to 
> encourage the PHP user community to switch to PostgreSQL.
> 
> What I'm worried about is exactly the people who adopted MySQL already. 
> The change to another database will be painfull no matter what. How many 
> of them will be willing to give another open source database a shot?

If you assume that cost is one of the factors in going with an open
source database, what are their choices?  

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

MySQL also does case independent text comparisions, and apparently ONLY
case-insensitive comparisons.  
--
Mike Nolan

In response to

Responses

pgsql-docs by date

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

pgsql-advocacy by date

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

pgsql-general by date

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

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