I was running some benchmarking and testing on MySql MyISAM and InnoDB database engines when I suddenly realized that the queries executed by MySql weren't cached, ie. the qcache_hits variable wasn't hit or get incremented. Apparently, if a stored procedure has one or more parameters (for example, sp_query_not_cache (int i)), the queries are not cached. Hmm.
So that means, not one of Covalentia's many queries to the database will be cached. Oh well.
So that means, not one of Covalentia's many queries to the database will be cached. Oh well.
No comments:
Post a Comment