Re: Fw: mysql ? sybase ? oracle ? postgres ?

> Can you outline what your requirements are? - we have 126,000 users all together. - max_connections is set to 200 as 100 wasn't good enough. usually between 150-250 connections - relational database of 50 or so tables. - at the most we have queries with 4 joins. most of our queries cross over two tables. - i'm re-designing the database structure to reduce the number of joins - but i think we will still need to do three joins for some queries. is it better to have several simple queries on a page instead of one big query with 4 joins? thanks anna > How many tables would you ideally join in the most complex query? (Assuming > you can have a nicely normalised datamodel.) > > No question, Oracle is far more powerful then any competitor, but it's also > far more expensive! You should also look into optimising your database calls > from PHP. For example try to get as much information out in a single query > and directly into PHP and then do all the "data dissimenation" in PHP. This > can reduce DB load and increase performance. > > To answer what's best for you, you should illustrate what your requirements > are in more detail. There is no "one fits all" answer for the "best" DB. > > Cheers > > Marc > > ============= > Marc Burgauer > Project Manager > Stortext Ltd. > 1 Atholl Place > Edinburgh, EH3 8HP > Tel: 0131 221 8514 > Fax: 0131 221 8501 > marc.burgauer@stortext.com > > > -----Original Message----- > > From: Anna Soobrattee [SMTP:annazaraah@yahoo.com] > > Sent: Monday, September 11, 2000 12:19 PM > > To: php-general@lists.php.net > > Subject: [PHP] Fw: mysql ? sybase ? oracle ? postgres ? > > > > > Hi, > > > > > > So far my company has been using freebsd-mysql-php for our > > webserver. > > > However recently, the whole server's speed and has deteriorated > > > substantially ( multiple joins, long queries, high traffic). I've > > > denormalised our database as much as I could to reduce the number of > > > joins needed, however I think it is time that I moved away from > > mysql > > > and used another datbase server. > > > > > > Has anyone got any advice ? > > > > > > Sybase, Oracle and Postgres have all been recommended. Which one is > > > most compatible with PHP ? > > > > > > Thanks > > > anna > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > ------------------------------ > > > anna soobrattee > > > technical director > > > themutual.net plc > > > 0207 440 9315 > > > > > > > > > _________________________________________________________ > > Do You Yahoo!? > > Get your free @yahoo.com address at http://mail.yahoo.com > > > > > > -- > > PHP General Mailing List (http://www.php.net/) > > To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net > > For additional commands, e-mail: php-general-help@lists.php.net > > To contact the list administrators, e-mail: php-list-admin@lists.php.net > > _________________________________________________________ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com