|
On Wed, 2005-12-14 at 17:42 -0600, Scott Klement wrote: > > But certainly not to the level of 'READE is a dog! Change it to READ + > > condition for a big performance boost'. > > Heh... in this particular thread, where the OP was doing an update of > every record, specifying READ instead of READE shouldn't help at all, > since you can't use blockign when you're doing updates. So the people > responding with that weren't thinking it all the way through, anyway. > Exactly. > Like I said in an earlier message, the way you achieve optimal performance > is to try changing different things and benchmarking each one. See what > works best in your particular situation. Test, Test, Test. > > But in order to do that, you need to know what the options are and why one > is sometimes better (and sometimes worse!) than the others. And that's > where there's a lot of value in reading the various suggestions from > members of the list. Yup, I agree.
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2025 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.