Re: is this optimization?

null@example.com (lie2815) — Fri, 08 Feb 2008 13:44:08 +0000

cool. thx

null@example.com (Smartys) — Fri, 08 Feb 2008 11:34:19 +0000

Yes, that likely would be, I'll make the changes

is this optimization?

null@example.com (lie2815) — Fri, 08 Feb 2008 09:35:26 +0000

There are a few queries e.g in moderate.php, that do something like this:

'SELECT 1 FROM topics WHERE id IN ('.implode(',', $topics).')'

And then you compare the num_rows of the result to the count of the array $topics.

I don't know if this is really optimization, so - would it be faster to do a query like this?

'SELECT COUNT(id) FROM topics WHERE id IN ('.implode(',', $topics).')'

Thanks