Anything Good with Oracle Opensource?

tomakali posted 26th of August 2009 in Community Voice. 3 comments.

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?

Any Disadvantages? Advantages?

 
Comments
·Oldest
·Top
Please login to post a comment.
CodeSatori
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!
tomakali
Agreed!!! Still how would be the performance of D7 or later with the "disadvantages you mentioned fixed" when compared to the current D7+MySQL
CodeSatori
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.
 
 
Below is the legacy version of the Boonex site, maintained for Dolphin.Pro 7.x support.
The new Dolphin solution is powered by UNA Community Management System.
PET:0.051416158676147