Re: help with site+database
It has been been our experience (doing in-house development work) that
your choice of database (between mySQL and PostgreSQL) should be partially
based on the types of tables and queries you will use with your application(s).
mySQL appears to be extremely fast for simple queries. However, our developers
suffer with it because of its' limited support for advanced SQL functionality.
mySQL does not currently support subselects, foreign keys, stored procedures
or triggers. In addition, only mySQL version 3.23.X supports temporary tables
(version 3.22.32 is in Potato) etc.
Since 45000 visits/day is approximately one (1) connection/sec for
a twelve (12) hour day, I would say that, all other differences aside, either
database should perform satisfactorily.
On Tue, Jul 17, 2001 at 10:07:33AM +0200, TooManySecrets wrote:
> Hi.
>
> I'm constructing a new site from cero. The actual site is dinamic, with a
> database server (the DB is over 65 Mb big). The next site also will dinamic,
> but I would like to change the actual DB (a MS SQL 7) with MySQL or (better
> for my, I think) a Postgresql DB.
> The number of visits, actually, is from 9000 to 45000 visits per day.
> Can anybody tell me what of DB (MySQL or PostgreSQL) are better for me? Can
> explain me why? Can tell me any site about benchmarks, or any date about
> that? Any of these databases are too strong to support this number of
> visitors?
> The site will run with apache+php4, with database access optimized.
> Also, we have the Oracle 9i option, but we want to make this project under
> one of these open source option.
>
> Please, anybody can help me???
>
> NOTE: I will apologize about the inconvenience of my bad english. Sorry.
>
> Have a nice day ;-)
> TooManySecrets
>
>
> --
> To UNSUBSCRIBE, email to debian-isp-request@lists.debian.org
> with a subject of "unsubscribe". Trouble? Contact listmaster@lists.debian.org
>
--
Jean-Paul Stewart
Senior Systems Administrator
CarbonMedia, Inc.
114 East 25th Street, Eighth Floor
New York, NY 10010
Phone: 212.253.7180
Fax: 212.253.8467
http://www.carbonmedia.com/
Reply to: