Message-ID: <20030623025439.28324.qmail@celery.tssi.com>
From: nolan@celery.tssi.com
Subject: Re: [GENERAL] interesting PHP/MySQL thread
To: JanWieck@Yahoo.com (Jan Wieck)
Date: Sun, 22 Jun 2003 21:54:39 -0500 (CDT)
Cc: pgman@candle.pha.pa.us (Bruce Momjian),
	josh@agliodbs.com (Josh Berkus), mail@joeconway.com (Joe Conway),
	pgsql-advocacy@postgresql.org (\"Advocacy PostgreSQL\"),
	pgsql-general@postgresql.org (PostgreSQL-general)
In-Reply-To: <3EF655E7.9070709@Yahoo.com> from "Jan Wieck" at Jun 22,
	2003 09:20:39 PM
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

> 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