Jump to:

3372 Posts in 998 Topics by 712 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: 953 Views
  • swaiba
    Avatar
    Forum Moderator
    1769 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
    1769 Posts

    Re: Indexing of DataObjects Link to this post

    Thank you Mark

    953 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.