>I have a 1 million row table with a primary key of RECNO(). I need to pull random sets of 100 contiguous rows from the table. I have tried 3 things:
>
>1) SELECT * FROM table WHERE PriKey>=N AND PriKey>2) SEEK followed by COPY TO ARRAY
>3) SEEK followed by SCAN
>
>All three get a throughput of about 10 requests per second. This seems slow to me. Would anyone disagree? Can you suggest a better way to do the requests?
>
>Especially in the SCAN case I am puzzled. It would seem that all FoxPro has to do is read the records sequentially (I tried using SET ORDER TO 0 and NOOPTIMIZE), yet my disk's average transfer rate is 5 times what I am seeing and my CPU is at 15%.
>
>Also, in the SELECT case, I am collecting statistics and I see some requests taking 10 milliseconds and others taking 450 milliseconds. Based on the ranges requested, it does not look like buffering is causing the speedy ones so could disk fragmentation be causing the slow ones?


When using a SELECT to a cursor, make sure you use the NOFILTER qualifier after the cursor name (i.e. SELECT field FROM table INTO CURSOR temp NOFILTER WHERE yada yada. Without the NOFILTER, VFP will USE AGAIN with a filter which takes forever sometimes.

HTH

CySolutions, Medical Information Technology
You're only as good as your last
success, so . . .If it works. . .don't fix it!