Slow select queries after update

[Geir Øyvind Vælidalo]

Hi all,

I'm a developer, fairly new to MySQL and I have recently gotten the responsibility for a PHP/MySql-webapplication.

My problem is that after a simple UPDATE, a certain webpage is being refreshed.
The page's SELECT-queries are then executed ten times slower than usual. It takes 5 seconds to load, instead of just 500ms.
The problem is definitively caused by the UPDATE. The update takes just 50-100 ms to execute, but all the following SELECTS are dead slow.

The update sets a new value in one column in a table with 94k rows, so nothing spectacular.

Do any of you have any suggestions to a solution for this?

Thanks!

Geir Øyvind Vælidalo