开发者

group similar queries in mysql

I have page with lot of users (cca 80k) so I need to save execution time of every query. I was wondering if there is a way to group same queries and give just one result. For example: "SELECT COUNT(*) FROM user" [obviously query that counts number of users on page :)] is executed every time the page is reloaded. My idea is that e.g. 10 users execute this query in same time, the first user queries DB and the others get only "outdated" cached result of first user. Is it possible to make this somehow in DB with some settings? Thanks for help.开发者_开发技巧

M.


MySQL Reference Manual :: The MySQL Query Cache

memcached - a distributed memory object caching system

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜