> Although I will reply to Tom's questions soon, what suggestions do you
> have to ensure that I'm not optimizing incorrectly?
I wasn't aiming the "sucks hard" comment at yourself -- it's a very
common response. So apologies if it seemed that way.
-- optimising
You can't optimise incorrectly. You just have to make sure that you
optimise frequently enough to keep the fragmentation of the index down.
-- indexing
Make sure that the collection fragmentation is minimised by doing bulk
updates rather than lots of little updates.
-- REFERSH vs UPDATE
REFRESH effectively purges the entire collection and rebuilds from
scratch. This might be ok for spring cleaning or smaller collections
but for large collections can make updates very labour intensive.
-- geoff
http://www.daemon.com.au/
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
