[geeklog-devtalk] Optimizing MySQL (was: SPAM Article)

[Dirk Haun]

Michael Jervis wrote:


>DELETE FROM [table] speeds things up one hell of a lot I find


The biggest tables on geeklog.net are forum_topic (in terms of size) and
forum_log (in terms of number of entries), so let's start there ...

I'm only half joking, actually. Why exactly does the forum_log table have
to have 370,000 entries? I guess it's keeping track of the read/unread
topics per user, but I wonder if it couldn't be more compact. Blaine?

bye, Dirk


-- 
http://www.haun-online.de/
http://www.handful-of-sparks.de/