[aur-dev] [PATCH 2/5] Always set ModifiedTS including new packages

[Dan McGee]

On Wed, Mar 30, 2011 at 9:13 PM, elij <elij.mx at 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