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

[Blaine Lang]

Dirk,

Yeh the log tracks what topics a user has already viewed. It's indexed but 
I've not looked at that code in a while and may need to add some debug code 
to see if it's effecting performance.

Note to self: Install some debug code on geeklog.net to track timings to see 
if there is a perf issue.

Blaine
----- Original Message ----- 
From: "Dirk Haun" <dirk at haun-online.de>
To: <geeklog-devtalk at lists.geeklog.net>
Sent: Thursday, March 03, 2005 3:01 PM
Subject: [geeklog-devtalk] Optimizing MySQL (was: SPAM Article)


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/

_______________________________________________
geeklog-devtalk mailing list
geeklog-devtalk at lists.geeklog.net
http://lists.geeklog.net/listinfo/geeklog-devtalk