3068 Posts in 868 Topics by 650 members
|
Page:
1
|
Go to End | |
| Author | Topic: | 862 Views |
-
Indexing of DataObjects

2 June 2010 at 4:18am
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
-
Re: Indexing of DataObjects

3 June 2010 at 11:26pm
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
| 862 Views | ||
|
Page:
1
|
Go to Top |


