Jonathan Vanasco wrote:
can anyone offer some suggestions on tweaking a system for
write-intensive operations?
but the updating of the records as having been audited ( a bool flag )
takes 5-10 minutes per set.
What's the limiting factor? Disk? CPU?
Any chance of seeing the queries that are causing the problem?
How many rows do they affect?
Do you have lots of indexes or foreign-key constraints that might be
taking up time to update/check?
Do your logs show messages about checkpointing happening too often?
--
Richard Huxton
Archonet Ltd
