Jump to:

3460 Posts in 1064 Topics by 739 members

Data Model Questions

SilverStripe Forums » Data Model Questions » Indexing of DataObjects

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

Page: 1
Go to End
Author Topic: 1002 Views
  • swaiba
    Avatar
    Forum Moderator
    1792 Posts

    Indexing of DataObjects Link to this post

    Hi,

    I am no professional DBA, but I am curious if there are any basic things I could do to future-proof a system that I expect several tables to grow massively on. I am aware of indexing tables based on keys - I wondered if silver stripe creates indexes in anyway? If so do these relate to the default sort or something else I can configure on the data objects?

    Barry

  • mark_s
    Avatar
    Community Member
    78 Posts

    Re: Indexing of DataObjects Link to this post

    Hi.

    When you define a DataObject derivative, you can define a static called $indexes which defines the indexes. When SilverStripe builds the database, it also creates these indexes. So yes, you can get performance out of large tables.

    Mark

  • swaiba
    Avatar
    Forum Moderator
    1792 Posts

    Re: Indexing of DataObjects Link to this post

    Thank you Mark

    1002 Views
Page: 1
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.