Quote:
Originally posted by HQ
not hitting any swap, my processes hardly touch memory at all. mysql is just taking a lot more resources than i thought it would... that's why i'm wondering if it's just my code or if it typical for a 400MHz system to be too slow.
|
400MHz isn't fast, and upgrading might help, but chances are you could improve performance by reducing complexities in the code, or caching more data. say you do a select query every second that adds up all the values related to a specific key - it might be worthwhile to have a cron job generate that every minute, store it in a separate table, and then you could add the values in the new table to only the most recent values from the old.
yeah, that's a wild "for instance", but it's just an idea. ;)