can anyone offer some suggestions on tweaking a system for write- intensive operations?

my new box is running great for reads / selects , and with 60 connections on tests.

however i'm in the middle of a schema migration / audit, and its taking ungodly slow.

selecting + analyzing 10,000 records with thousands of queries is no issue -- its only taking ~ 3 seconds.

but the updating of the records as having been audited ( a bool flag ) takes 5-10 minutes per set.

the read and write operations are pulling up the data via the relevant indexes according to analyze.

i've tried turning fsync off, but no luck there.

if anyone could suggest some improvement tips, i'd be grateful. the system isn't huge (only ~5M records ) , but its taking a rather long enough time that any extra speed i can come up with would be a huge improvement..


// Jonathan Vanasco

| - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
| FindMeOn.com - The cure for Multiple Web Personality Disorder
| Web Identity Management and 3D Social Networking
| - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
| RoadSound.com - Tools For Bands, Stuff For Fans
| Collaborative Online Management And Syndication Tools
| - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -



---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Reply via email to