summaryrefslogtreecommitdiff
path: root/ChangeLog
diff options
context:
space:
mode:
authorYorhel <git@yorhel.nl>2010-11-07 11:01:17 +0100
committerYorhel <git@yorhel.nl>2010-11-07 11:01:17 +0100
commitab64b573846da39622b8d430b079d7e8806a35d3 (patch)
treea25c92d595655d21ad1ba0bf02842cf05de9e51e /ChangeLog
parent466f45685e420574647eef75d32b83e1126c9e0a (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--ChangeLog1
1 files changed, 1 insertions, 0 deletions
diff --git a/ChangeLog b/ChangeLog
index 5b050df9..d97dcd5a 100644
--- a/ChangeLog
+++ b/ChangeLog
@@ -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