Quote:
Originally Posted by http
So a plain "update site_table WHERE site_name='site-name' ..." etc will do?
|
Something like:
Code:
UPDATE site_table SET columnCounter = columnCounter + 1 WHERE siteID = 2134;
Quote:
Originally Posted by http
I haven't done much update queries yet, I am mainly doing selects and thought updates would be much more expensive. Server in question is a Seprom w/ 512MB (and quite busy with just the selects) but getting a Core 2 Duo 2.4 w/ 2GB Ram & Raptor drive soon.
|
What else is that Sempron box doing (or approx how many selects are being done?) and what's the average load on high-traffic periods? You sure it's mysql that is hitting the bottleneck? If a web server is being hosted on the same server, that could be it as well.