Oracle Databases on Windows
Saturday, October 11th, 2008We have done a lot of Database work using PHP applications and nine times out of ten we end up using an MS SQL server backend instead of the standard mySQL backend. MS SQL has so many plus points compared with mySQL, the biggest being speed, recovery, backup and database management.
We have, however, been testing with Oracle in the past month or so. As most of us here come from a DBA background and are used to using Oracle in large Banking and Financial systems, we would choose Oracle at the drop a hat if the TCO was in the right ball park. With the release of Oracle on windows, it has now come into the same ball park as MS SQL, and having access to Oracles RAC would be a great advantage as it seems to be even better than MS SQL 2005 mirroring.
We will let you know how our testing gets on and we will hopefully have some benchmarks between MS SQL and Oracle 11g to show how they get on with PHP.