Re: DB Comparisons

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Larry Garfield wrote:
On Thu, 05 Feb 2009 12:36:02 -0800, revDAVE <Cool@xxxxxxxxxxxxxxxx> wrote:
Hi Folks,

I¹m curious if there are any previous discussions / Articles / URL¹s
that
compare the power and scalability of MySQL (with php) with other
technologies like MS sequel server oracle -  coldfusion etc....

I imagine that most middleware like php / asp / coldfusion is relatively
good & fast - (let me know if one is better ).  Mostly I¹m concerned with
the speed and power of the backend database as to how it functions on an
enterprise scale ­ such as how many hits it can handle per hour ­ how
many
users before it starts to slow down etc.

1) Define "enterprise scale".  The word "enterprise" has no useful meaning other than "your software isn't ready for it, therefore you suck". :-)

2) How well do you know your DB?  A well-tuned MySQL database will blow the crap out of a default config PostgreSQL server, but a well-tuned PostgreSQL server will wipe the floor with a badly configured mySQL database.  Your knowledge of the underlying tool and how to get the most out of it will matter more than which vendor you go with, unless there are very specific features you require.

On top of that, the types of queries you run will have an effect. Mysql works well with simple select * from table where id='x' type queries. Add some subqueries, aggregates (count/sum type thing) and it doesn't perform so well.

--
Postgresql & php tutorials
http://www.designmagick.com/


--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux