YaBB SE 1.0 Version Indexes

[Ralph Button (rbutton)]

As a result of the numbers of messages posted on our site I have begun looking at the code as well as the database.  What I noticed was selects being done on tables that had no index on the select field.  Is this something that has been looked at in other releases?

I added various indexes and suddenly the topic screens loaded much faster.  By looking at the code for the select statements then comparing that with the indexed fields in the database I added "missing" indexes to match to the select statements.  

[Jeff Lewis]

Yes it IS being looked at for future releases and will be used.

For SE, we ported over already difficult code from Y1G and as such, you will see many things that don't look right or places that can be improved on.

[Ralph Button (rbutton)]

Like any code it can be improved on just wanted to be sure it found it's way on the list of possible improvements.  As making changes to the indexing sure improved the speed to load posts!!  
At 23,000+ posts and 3705 topics in a couple of months it was already bogging down, loading the screens with the messages.
My first crack at it was to add single column indexes.  My next go is to create indexes on multi columns based on the selects being done and drop the single column indexes.  You don't want the indexes to be too many or it's begins to affect inserts into the database.  
As my ISP has given me the "keys" to the server I now have much more control over the database setup.