[Oblivion Knight]

[QUOTE]05-01-03 at 07:18 PM eoc_Jason said this in Post #402
Oh yeah, btw.... I was experienceing forum slowdown's, especially during peak time, and it was the worst on the forumhome... well I ran the sql explain stuff and found out that the line:

PHP Code:

$getnewpost=$DB_site->query_first("SELECT count(*) AS posts FROM post WHERE dateline > '$bbuserinfo[lastvisit]'"); 


was causing a major slowdown because there was no index on post.dateline, if you add an index on it (and thread.lastpost for good measure since it has a similar query) you should see a nice speed improvement, especially if you have a good number of posts (my forum is approaching 400,000).