Hi guys!
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 INFORMATION_SCHEMA
.TABLES
WHERE TABLE_NAME
='xxx'
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.