Overgrow - may I suggest you select your "ignorelist" in global.php on the same line where everything else is already being selected for the user instead of running a seperate query in showthread. Doing it this way will not add the same overhead even though it will effectively be available on every page.
if ($userinfo=$DB_site->query_first("SELECT daysprune,lastvisit,lastactivity,cookieuser,userna me,password,usergroupid,timezo neoffset FROM user WHERE userid=$bbuserid")) {
Add "ignorelist" to that line.
Also "ignorelist" is a blob field and that will effect performance.
[Edited by rangersfan on 09-28-2000 at 12:29 PM]
|