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).
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).