diff options
author | Yorhel <git@yorhel.nl> | 2010-11-07 11:01:17 +0100 |
---|---|---|
committer | Yorhel <git@yorhel.nl> | 2010-11-07 11:01:17 +0100 |
commit | ab64b573846da39622b8d430b079d7e8806a35d3 (patch) | |
tree | a25c92d595655d21ad1ba0bf02842cf05de9e51e /ChangeLog | |
parent | 466f45685e420574647eef75d32b83e1126c9e0a (diff) |
Optimized random screenshot fetching query
By rewriting the query and using the trick documented here:
http://blog.rhodiumtoad.org.uk/2009/03/08/selecting-random-rows-from-a-table/
Can be further optimized by putting an index on vn_screenshots.scr
Diffstat (limited to 'ChangeLog')
-rw-r--r-- | ChangeLog | 1 |
1 files changed, 1 insertions, 0 deletions
@@ -3,6 +3,7 @@ cross-site request forgery vulnerabilities - URL change: /u/logout => /u$id/logout - Bugfix: delete/update all references when deleting a user + - Optimized random screenshot fetching query 2.12 - 2010-11-03 - !scr command for Multi::IRC |