Page 1 of 1

DSPDB Table Indexes

Posted: Sun Mar 23, 2014 10:39 am
by viion
Hey,

I was setting up a local server to do some website portal testing of my own, and looking through DB there are practically no indexes setup on the tables other than your very basic primary keys and the odd table here and there.

Is there a reason for this?

Re: DSPDB Table Indexes

Posted: Sun Mar 23, 2014 12:32 pm
by atom0s
More or less an overall lacking of much optimization to the database tables. Things are not really setup well to handle fast and easy queries between tables. You are more than welcome to add them and submit your changes via a pull request on Github though. Just be sure to test things out and ensure nothing breaks from the changes.

Re: DSPDB Table Indexes

Posted: Sun Mar 23, 2014 1:03 pm
by viion
Ah okay, neat. I wasn't sure if there was a specific reason for XI why limited index's were there, but good to know, i might just do that. I'm building a sort of web portal for funsies, and will probably have a look at indexes soon. I don't know what type of queries you do, but a lot is primitive data which can probably index'd and most joins are obvious.