[blazin]

i have had this hack installed for quite some time, but ecently it has taken the forum very long to post a new thread or submit a reply.

I found out the slowness was due to this hack, particulary this line of code:

$attachcount = $DB_site->query_first('SELECT COUNT(*) AS total FROM attachment WHERE userid='.$bbuserinfo['userid'].' AND dateline>('.time().'-3600*'.$limitattachtime.')');

My attachment table is about 370MB with 7,700 records. When I make a simple query to this table in phpmyadmin, its very slow to respond also.

The rest of the site is extremely fast, any suggestions?