Recently i came upon http://oss.oracle.com/oracle-database-xe.html and tested in our company intranet looks cool and worthy. Now Guessing what improvements can D7 get with OracleXE?
Advantages: Possibly better performance in some environments.
Disadvantages: Changing every database-query to support a dual database setup. Writing new or revising existing queries for Oracle for every database operation. Debugging every possible situation where the queries are used.
I think Boonex have enough on their plate as it is without tackling the above!
Unless you have huge volumes of traffic, it's unlikely to make much of a difference. If you do get huge volumes of traffic, some of the higher-end Oracle solutions will be excellent, if you have the money to invest into the software. The free Oracle XE is a low-to-medium range entry level solution.
In an application like this, and at the volumes most of us receive, it's more a question of how smart the database queries are written. If your application runs on well-optimized MySQL queries, and see more if you get low to medium traffic, it's unlikely your site will get noticeably faster with a different database software.
Then again, if you are running a very high-volume site, there are ways of further optimizing MySQL for heavy stress performance. You will have to have a huge site and rather particular needs to justify adopting a different database solution, given the extent of support MySQL enjoys in the current hosting environments.
Disadvantages: Changing every database-query to support a dual database setup. Writing new or revising existing queries for Oracle for every database operation. Debugging every possible situation where the queries are used.
I think Boonex have enough on their plate as it is without tackling the above!
In an application like this, and at the volumes most of us receive, it's more a question of how smart the database queries are written. If your application runs on well-optimized MySQL queries, and see more