Re: disk I/O problems and Solutions

[Alan McKay <alan.mckay@xxxxxxxxx>]

> Since you stated that your system is only having trouble at writes,
> doing batch inserts, I would look at how you are doing these batch
> inserts and see if you can optimize this by using techniques to delay
> key writes or adjust locking mechanisms on the insert. Some databases
> have special insert from file or bulk insert operations that are much
> faster than running many single row inserts - be sure you are taking
> advantage of these methods.

Yeah, our DB geeks have already said a few weeks ago that they think
we are doing these bulk updates in a pretty inefficient manner, so
that's something else we plan to optimize.



-- 
“Don't eat anything you've ever seen advertised on TV”
         - Michael Pollan, author of "In Defense of Food"
_______________________________________________
CentOS mailing list
CentOS@xxxxxxxxxx
http://lists.centos.org/mailman/listinfo/centos