Skip to main content

This site requires you to update your browser. Your browsing experience maybe affected by not having the most up to date version.

We've moved the forum!

Please use forum.silverstripe.org for any new questions (announcement).
The forum archive will stick around, but will be read only.

You can also use our Slack channel or StackOverflow to ask for help.
Check out our community overview for more options to contribute.

General Questions /

General questions about getting started with SilverStripe that don't fit in any of the categories above.

Moderators: martimiz, Sean, Ed, biapar, Willr, Ingo, swaiba

PostGreSQL or MSSQL?


Go to End


1408 Views

Avatar
njprrogers

Community Member, 23 Posts

2 March 2012 at 5:11am

Hi,

I have SS 2.4.5 running at the moment using MySQL.

This is a mature installation with 60 + page types (the site is multi-company and multi-country).

Unfortunately, 61 is the upper limit on page types with silverstripe and mysql.

See http://dev.mysql.com/doc/refman/5.0/en/error-messages-server.html - error 1116. Basically, you cannot do a join on more than 61 tables in mysql and this is exactly what the sapphire ORM does!

So I am looking at moving SS to another database which does not have this limitation.

- Is PostGreSQL stable with Silverstripe? We run the blog module and the cmsworkflow module.
- Is MSSQL more stable? What is the communities experience with running using a MSSQL database server?
- Is the conversion from MySQL to PostGreSQL or MSSQL straigthforward?

Does anyone have sites out there running these other database options? From looking at the forum it looks like MSSQL is less flaky than PostGreSQL but there is not a lot of info and some of the posts are old.

Thanks in advance for your feedback!

Nick