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

[Vincent Furia]

Blaine,

I'm pretty sure there is some performance problems there... 
Consistently the slowest page load for me at geeklog.net is
http://www.geeklog.net/forum/index.php?op=newposts.  It's usually at
least 4x slower than any other page load and is often 10x slower.  I
think it'd be worth while to look into, even if the table can't be
optimized perhaps whatever join you do can be.

-Vinny


On Fri, 4 Mar 2005 10:16:08 -0500, Blaine Lang <geeklog at langfamily.ca> wrote:

> 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