Urgent!! Database Help Please

Anon

Hello Every body,
I am using DB2 as the backhand in one of my project. I am using ODBC connection of the DB2 to access my database. I wanted to know that is any one aware that how when multiple requests comes to the PHP how does it manages the Database requests. I meant to say that how are the concurrent connection to site is managed by site. If there are 300+ concurrent connections in my site what will be state of the PHP Site.How does PHP manages the database resources. Is there any thing like Database pooling in the PHP. Shoule i use CF or JSP or PHP for the site which has say 300+ concurrent requests at peak times. I need to say speed plus efficiency which language will be Best.

--Thanks
NV

Anon

300 concurrent requests = 6 load balanced servers each with ~ 1ghz + ~1gb ram. all running apache with php.

have some slave mysql servers for just selects, and cache pages as much as possible (things that may be requested more than, lets say, 10 times before they are updated)

then another mysql server (dual 1.4 ghtz, > 1gb ddr pc2100, scsi <4ms seek) for the main database. hopefully this is an intranet project or you are going to be spending through the teeth on bandwidth.

this of course is the setup you'll want for web-acceptible request times... you could do it all on one quad processor machine with 16 gigs of ram (sun E450), but you really need a more scalable solution.

look here:
http://www.rackspace.com/complex/complex_configurations.php?ctid=0101-99999

looks like you'll spend $5000-$10000 a month if you outsource it. i would be happy to set this all up for you cheaper if you have the money.

smarlowe

You need to benchmark some synthetic test pages to get an idea of which is a best fit for you.

I wouldn't do this in Cold Fusion, but JSP or PHP or mod_perl or fastCGI C++ can handle it fine.

The real critical issue is your database hardware, software, and design. If you don't use fast enough hardware and software, and if you don't design your database properly, it's never gonna work, conversely, most dual PIII 800 boxes can handle 300 or more apache/php children no problem. The real bottleneck will almost surely be the dbms subsystem, and no matter which dbms you choose, you WILL have to become an expert at both the OS your database runs on, as well as on the database itself.