On 10/21/05, Moshe Weitzman <weitzman@tejasa.com> wrote:
you are optimizing selects that are already very very fast. these are single table queries with a single condition on an indexed column.
i think that further optimizing drupal for the mysql query cache is a more involved effort. you have to simplify queries in order to avoid DISTINCT(), COUNT(), SUM(), etc. that often means performing subqueries or multiple successive queries.
with mysql query cache enabled, i am seeing pages using 50ms of total query time. not much to improve upon IMO.
I think the point here is that the fast (50ms) queries occur on a cache hit. Splitting the cache table would increase the probability of cache hits as the entire cached data set won't be invalidated for every cache change. -- Best regards, Herman Webley