From: nolan@celery.tssi.com
To: JanWieck@Yahoo.com
Cc: pgman@candle.pha.pa.us
Cc: josh@agliodbs.com
Cc: mail@joeconway.com
Cc: pgsql-advocacy@postgresql.org
Subject: Re: [GENERAL] interesting PHP/MySQL thread
Date: Sun, 22 Jun 2003 21:54:39 -0500 (CDT)
Message-ID: <20030623025439.28324.qmail@celery.tssi.com> (raw)
In-Reply-To: <3EF655E7.9070709@Yahoo.com>
> 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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-docs@postgresql.org
Cc: nolan@celery.tssi.com, JanWieck@Yahoo.com, pgman@candle.pha.pa.us, josh@agliodbs.com, mail@joeconway.com, pgsql-advocacy@postgresql.org
Subject: Re: [GENERAL] interesting PHP/MySQL thread
In-Reply-To: <20030623025439.28324.qmail@celery.tssi.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox