Quote:
Originally Posted by http
So a plain "update site_table WHERE site_name='site-name' ..." etc will do?
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.
|
Mysql needs alot of ram so I would wait until you upgraded, but certainly you NEED to track all hits in and out and analyze that data or you are throwing money away.