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

[Blaine Lang]

Looking at the code again this afternoon: The forum_log table is used to 
track what posts a users has already viewed. To eliminate this table has 
having any effect on performance, you only need to compare page load times 
(for a logged in user and a non-logged in user) for a specific forum's topic 
page. If you are not logged in, the logic and SQL for checking what topics 
you have read is not executed.

Just doing some quick testing on geeklog.net with 26 users online did not 
show much of a difference in page load times. This table is really only 
accessed and updated when viewing the forum index pages. It's also updated 
when viewing the topic itself (if the user is logged in).

Blaine
----- Original Message ----- 
From: "Vincent Furia" <vfuria at gmail.com>
To: <geeklog-devtalk at lists.geeklog.net>
Sent: Friday, March 04, 2005 10:46 AM
Subject: Re: [geeklog-devtalk] Optimizing MySQL (was: SPAM Article)


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

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