Jump to:

3460 Posts in 1064 Topics by 739 members

Data Model Questions

SilverStripe Forums » Data Model Questions » MySQL Out of sort memory; increase server sort buffer size

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

Page: 1 2
Go to End
Author Topic: 8605 Views
  • Willr
    Avatar
    Forum Moderator
    5508 Posts

    Re: MySQL Out of sort memory; increase server sort buffer size Link to this post

    DataObject:get doesn't seem to well thought through and optimised.

    DNA to answer your question DataObject::get is not (very) optimized and it does comes with the associated performance implications (try doing a DataObject::get('Page') on a ~20,000 page site!). You should use SS_Cache to cache any large sets from the front end if you want to keep tabs on performance.

    Planning has been underway for how to replace the current accessing structure (http://open.silverstripe.org/wiki/development/NewDataMapper) Sam has already tried his hand at initial versions of the new functionality so it'll hopefully make its way into SilverStripe 3.0! Keep watching this space.

    Another area a couple devs are investigating is how to reduce the number of queries SS makes. When you save a page in some parts of the CMS it can make a crazy amount of queries (one dev had ~700 per site publish) so its one area where the framework could use a bit of a cleanup.

    8605 Views
Page: 1 2
Go to Top

Want to know more about the company that brought you SilverStripe? Then check out SilverStripe.com

Comments on this website? Please give feedback.