"UPDATE x SET y = y + 1" taking very long?

02-16-2007, 06:28 AM

Hi,
we have performance issue that I do not understand. For some reason query

UPDATE query_cache SET hit = hit + 1 WHERE match_id = 1

takes very long (could be seconds) on even modest size database, and creating index for match_id does not seem to matter match. Shouldn't that be much faster? Or is there more efficient way to do "hit = hit + 1" ?