i am using PHP on Linux redhat and Apache. Considering continuing with MySQL, or move to Oracle
2007-03-17 16:47:01 · 3 answers · asked by Saar M 1 in Computers & Internet ➔ Programming & Design
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.
2007-03-17 16:50:28 · answer #1 · answered by Rex M 6 · 2⤊ 0⤋
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.
2007-03-17 16:55:11 · answer #2 · answered by John Q 1 · 1⤊ 1⤋
MySQL or Postgres will do just fine.
2007-03-17 16:52:08 · answer #3 · answered by Anonymous · 1⤊ 1⤋