Support Forums - View Thread

View Thread

The following is the text of the current message along with any replies.

Messages 21 to 23 of 23 total

How to speedup random locate or RecNo positioning ?

Sat, Sep 24 2011 3:23 AM	Permanent Link
Roy Lambert NLH Associates Team Elevate	Tim >You should get pretty good performance from this, and it should be much >quicker than the randomized Locates. My thoughts were that most of the performance loss would come from the random disk access screwing the various read ahead buffers rather than the Locate. Your comment makes me think I'm wrong. Roy Lambert
Mon, Oct 3 2011 9:44 AM	Permanent Link
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com	Roy, << My thoughts were that most of the performance loss would come from the random disk access screwing the various read ahead buffers rather than the Locate. Your comment makes me think I'm wrong. >> No, we're both correct. The index takes something that is random and makes it non-random, at least as far as the disk accesses in the physical index file for the table are concerned. -- Tim Young Elevate Software www.elevatesoft.com
Mon, Oct 3 2011 10:57 AM	Permanent Link
Roy Lambert NLH Associates Team Elevate	Tim >No, we're both correct. The index takes something that is random and makes >it non-random, at least as far as the disk accesses in the physical index >file for the table are concerned. That makes a lot of sense. Roy Lambert

« Previous Page	Page 3 of 3
Jump to Page: 1 2 3