By pendashteh on
Hi,
I'm starting a new project and I'm planning to implement it based on Drupal framework. The project, after running, will have a huge amount of content creations, most of them play the role of logging. and there is need of keeping all of them in the sake of usage and financial reports.
So I considered if I face reliability problems with MySQL when data grown. Though I'm using a dedicated server I have no limit on resources.
Then, should I (and do you recommend) using Oracle in sake of reliability and is it stable enough with Drupal7?
Comments
_
Both d7 and oracle support are very very new-- you're probably best off posting this question to the oracle driver module's issue queue.
.
The majority of drupal developers develop, sadly, soley for MySQL. However, it looks like the Oracle driver project is maintained and production-ready. Oracle is closer to PostgreSQL so if you see issues with one it probably affects the other too, but not necessarily. You may also want to check out PostgreSQL.
Like the PostgreSQL users, you will want to test each module on a case-by-case basis as not all module developers are aware of issues that creep up. This should be less of a problem in Drupal 7 than it was in Drupal 5 or Drupal 6.
However, personally and professionally, we haven't found any reliability issues with MySQL or with PostgreSQL. If you do have the resources to implement Oracle, including maintenance costs, and you are dealing with transferring astronomically large amounts of data, then by all means, try out Oracle.