MySQL Forums
Forum List  »  Optimizer & Parser

Query cache
Posted by: Markus Doppelbauer
Date: October 31, 2006 01:32PM

Hallo,

Cached query:

select title from table where id = 1;

Get this query removed from the query-cache, if I execute one of the following update-queries?

update table set clicks = clicks + 1 where id = 1;
update table set clicks = clicks + 1 where id = 2;

Thank you very much for your help
Markus Doppelbauer

Options: ReplyQuote


Subject
Views
Written By
Posted
Query cache
2864
October 31, 2006 01:32PM
2053
October 31, 2006 04:12PM
1995
November 01, 2006 06:27AM
2034
November 01, 2006 12:25PM
2121
November 02, 2006 03:11AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.