What database should I choose for scaling a web 2.0 application? 10 million users - mostly select on tables.?

i am using PHP on Linux redhat and Apache. Considering continuing with MySQL, or move to Oracle

What database should I choose for scaling a web 2.0 application? 10 million users - mostly select on tables.?
It depends. If you are looking at extremely high transaction volume on small amounts of data (hundreds of thousands of rows or less), MySQL should do the job just fine. However, if you anticipate having to run many transactions on huge volumes of data (many millions of records), and need really fast response times, go with Oracle.





Also, make good use of caching. Effective caching your data in the business layer will cut down on your database transaction volume by a huge amount.
Reply:MySQL or Postgres will do just fine.
Reply:Follow the rest of the LAMP architecture and go with mysql. Look into which internal tweaks and dbs to maximize performance ie innodb vs any other, based on how it will be used mostly (transactional, read-only etc). You are going open source with L)inux A)pache M)ySQL and P)hp. With Oracle you would be spending some serious money. Stick with the freebies and twink it based on how it will be used.

cat teeth