This query
PHP Code:
$postbits = '';
$counter=0;
$postdone = array();
$sigcache = array();
$attachmentid=$DB_site->query("SELECT attachmentid,filename,visible,counter FROM attachment");
while ($attachmentbit=$DB_site->fetch_array($attachmentid)) {
$attach_id[$attachmentbit['attachmentid']] = $attachmentbit['attachmentid'];
$attach_filename[$attachmentbit['attachmentid']] = $attachmentbit['filename'];
$attach_visible[$attachmentbit['attachmentid']] = $attachmentbit['visible'];
$attach_counter[$attachmentbit['attachmentid']] = $attachmentbit['counter'];
}
the rest is php script, i havnt noticed any speed change when the forum loads even when the page has 100 posts.