[filburt1]

Today at 04:00 PM Boofo said this in Post #18
filburt, is it bad to use the * in this query then?

$yourposts = $DB_site->query_first("SELECT forum.forumid as forumid, forum.* as foruminfo, COUNT(post.postid) as yourposts FROM forum, thread, post WHERE forum.forumid=thread.forumid AND thread.threadid=post.threadid AND post.userid='".$bbuserinfo[userid]."' AND forum.forumid='$forumid' GROUP BY forumid ORDER BY yourposts DESC LIMIT 1");

Very much so because it's getting all forum columns instead of the ones that are needed. It's great for expandability in the templates but otherwise is just a performance hit.