>> Is there any way I can get the best of both worlds?
>
> Hmm, how about a multiple column index on (topic, created)? You might
> need to use
> select * from articles where topic='Example' order by topic desc, created
> desc limit 5;
> to get it to use the index though.
That works beautifully, thanks!
-J