[nemesis-]

Quote:

Originally Posted by JernejL Optimize your update queries and table design then. also, this doesn't belong in this forum sections.

You can make a fair amount of assumptions here:
1) He doesn't sound like a very experienced coder so his tables are likely very simplistic with few columns.
2) His queries will be simple so there is little to nothing to optimize
3) 150ms for a query that writes is a significant amount of time
4) His tables likely have little data so indexing isn't going to make that huge of a difference

With these assumptions in mind, I'd say that he is having disk i/o issues on an update which takes 150ms. I have fairly complex/indexed queries (multi-joins, sub-selects, etc) which only take 5-7ms and similarly with updates.