I would like to recive some information/expirience about dealing with huge amount of content in SilverStripe (in CMS). I'm starting a project that is not just simple information page - it may contain lot of pages after some time.
Let's assume that there is a page with NEWS section. Daily editors can add about 10 news-es (news is just a few paragraph - standard content). After a year we can assume that we might have no more then 3650 newses.
I wonder if SS will face it with no problems. I did some test and I added 10000 newses to simple page (I did it via database inserting rows to table SiteTree and to table NewsPage - this was table made by SS for my data structure). After that SS stuck. I crop rows to 5000. Still stuck. After cropping to 2000 newses SS started to replay (it was on localhost). The errors that I did recived during tests was pritty obvious, Allowed memory size bytes exhausted in sapphire/core/model/DataObject.php, sapphire/core/model/Translatable.php, sapphire/core/Object.php etc...
Those errors do not worried me. I understend them and I know why the occured.
Question is how to deal in such case when page will have more then 2k newses, maby some more articles or some other pages in amount greater then 2k. I think there have to be a way to configure CMS in such way that it will deal with that.
I wonder what are your throughts / expiriences / advice in that case.
Pawel