Gossamer Forum
Home : Products : Gossamer Forum : Discussion :

GForum Performance - MAX(n) vs ORDER BY n LIMIT 1

Quote Reply
GForum Performance - MAX(n) vs ORDER BY n LIMIT 1
Hi Adrian,

Another thing I've noticed:

GForum performance is drastically improved (under MySQL 4.1) if I make code changes to use ORDER BY n LIMIT 1 instead of MAX(n)
My guess, is this is a MySQL MyISAM specific optimization... but good to take into account for next versions of GForum (if not already planned/implemented).
Subject Author Views Date
Post GForum Performance - MAX(n) vs ORDER BY n LIMIT 1 jaltuve 2806 Nov 15, 2007, 1:30 PM