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're retiring the forums!

The SilverStripe forums have passed their heyday. They'll stick around, but will be read only. We'd encourage you to get involved in the community via the following channels instead:

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



Community Member, 23 Posts

2 March 2012 at 5:11am


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 - 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!