nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

MySQL or Commercial DB?

rstickle

Hi,

We are currently trying Alfresco for a possible company wide Document Management solution. Does anyone have any experience with large deployments using MySQL? The question we are working on now is whether to use an Oracle DB or MySQL.

Thanks.

Find more posts tagged with

Comments

pitt1

We have been using Alfresco over Oracle for the past year. We have performance issues, and we only have a few thousand documents loaded (mostly PDF and HTML). Simple operations like keyword queries take several seconds when they ought to take milliseconds.

We're currently investigating the potential causes of these performance issues, and one possible culprit is that perhaps the Alfresco DB schema isn't tuned as well for Oracle as it is for MySQL. For example with Alfresco 1.3.X, there were oracle FK indexes that were completely missing, and we had to run a custom script to generate them. Also, MySQL is known to be faster for certain types of operations than Oracle due to the fact that it's more lightweight. We also suspect the RDBMS platform because we have done other things that would make the system performant, such as moving indexes onto a fast local drive, making sure caching is turned on, etc. Our colleagues in another group have been using Alfresco as long as we have, but they've deployed it on top of MySQL on lesser hardware, loaded tens of thousands of documents, and get lightening fast performance.

FWIW, that's been my experience, and I'm currently trying to get Alfresco up and running with MySQL to see if it makes a difference. There could be other factors involved that I'm not aware of, and it would be nice to hear from one of the alfresco engineers as to the level of performance tuning for Oracle vs. MySQL…

rstickle

Thanks for the valuable feedback.

kevinr

Earlier versions of Alfresco undeniably ran better on MySQL - it is more optimized for it. In 2.1 we made a run through of all the common DBs - including Oracle - to make sure that indexes are added were required. Hopefully you should find 2.1 works just a nicely on Oracle as on MySQL - if not please let us know! Generally Alfresco is much heavier on the CPU than the DB - adding a faster CPU/more cores will generally give you a lot better performance increase than changing the DB.

Thanks,

Kevin

nicolasb

Hi,

Earlier versions of Alfresco undeniably ran better on MySQL - it is more optimized for it. In 2.1 we made a run through of all the common DBs - including Oracle - to make sure that indexes are added were required

I just read 2.1 should run on Oracle as fine as MySql. We are running on 2.0.1 (with oracle rdbms) and we are planing on upgrading it to 2.1.

Unfortunaly I can't find mention about such database optimization in release 2.1 http://wiki.alfresco.com/wiki/Release_2.1#Other_Enhancements_since_Release_2.0

What kind of optimizations are done ?

Thanks

Nicolas B.

kevinr

Confirmation and testing of indexes in the appropriate places.

Thanks,

Kevin

todd_acl

How about native XML databases?