On Wed, Mar 30, 2011 at 9:13 PM, elij <elij.mx@gmail.com> wrote:
It might be worth while to add an index on ModifiedTS as well. That would make sorting by ModifiedTS really fast for generating the rss and recent packages lists (as well as sorting aur results by date).
Granted, adding another index would make insertion or updates a tad slower, but I am not sure *how much* slower.
Dan, do you have any thoughts on adding an index for ModifiedTS? It might be a nice trade off with the removal of the DummyPkg stuff (and related dummypkg index).
That conversation we had on IRC the other day was in direct relation to this- for the package list, we don't use the indexes at all because our query isn't exactly how MySQL likes it. The only way I could convince it to use a index was remove most of the joins and drop the ORDER BY condition down to one column. The recent packages list is cached too, so although it would be used there we don't run that query more than once every 5 minutes anyway. -Dan