On Wed, 25 Feb 2004, Timwi wrote:
I find it *highly* interesting that so mnay people
appear to think that
most of the performance problems are related to CPU usage rather than
database queries.
I can't claim to have a lot of experience with this, but this seems so
highly unlikely to me. Concatenating two strings, even kilobytes large
ones, it *negligible* compared to database queries that search the
entire 'old' table, or create temporary tables, or do ridiculous amounts
of joins and that stuff.
Well, this is easy to settle. If a developer posts somewhere the load
averages of the DB server, web servers and squids, and can see what's
most taxed.
Again, a better expert than myself should probably correct me if I'm
missing something, but I don't think you can compare CPU usage in one
system with I/O usage in another (how would you relate the two?). We
don't really want to know which of the two is used "more" (whatever that
might mean); what we really want to know is where things are blocking
(i.e. which of the two is "overloaded"). Hm, did that make sense?...
Timwi