I've turned on profiling for my DB queries and one thing I'm seeing is something like
SELECT IF(COUNT(*)>0, 1 , 0) FROM
I'm wondering if that can be cached or avoided somehow? There's no point in executing this query every time I need to do something with a table...
I have to admit I didn't go through all of the documentation so I'm sorry if this is already written somewhere.