SV: [PHP] Stressing out db connections

Oracle cost some mony, But if your using Oracle's connection manager you have a enterprise Connection pooling built in. Which is much smarter than useing an external connection pooling. If you got some mony I should go for Oracle. And Oracle got foreign keys... The swedish yellow pages uses this. From a overloaded Sun Starfire Oracle database server down to 2-3% usage... //Jonas -----Ursprungligt meddelande----- Från: Jonathan Chum [mailto:jchum@techdevelopers.com] Skickat: den 6 augusti 2000 15:49 Till: php-general@lists.php.net Ämne: [PHP] Stressing out db connections I have worked on many small sites and now time is calling me for a high-usage site. Right now, we have a PII 400 with 64 MB PC133 RAM on Redhat 6.2 which will be used to jump start the site. What I want to know is how much connections to the database can be handled at once on the server, or perhaps some tips with the hardware architecture or software architecture would be much grateful. The site is a forum based site with over 1 million members at the start and increasing rapidly. What I also want to know what DB would be more suitable for the job, Oracle or MySQL? I have both and have written much of the forum software in MySQL which I don't think will be a big tuffy to convert over to Oracle. I hear that Oracle takes a great amount of RAM though just for the installation. Yet, in the long run, will Oracle should be my choice to power multiple boards with multiple users connected to a database simultaneously? Thanks for any help or insights you can give to me. -- 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