Yes I did reboot. I forgot to mention this is running over a Novell Network. When I run the tests on my local drive, performance is fine. Maybe it is the Novell Network?
Jerry is running his on a novell network also.

-Michael M. Emmons

>Did you reboot VFP after each query?
>
>>Hi Jerry.
>>
>>After reading this post I thought that I should check our data since I am rewriting an application to Visual Foxpro 5.0a from FoxPro DOS 2.6.
>>I found some interesting results that are similar to yours. Maybe someone can comment on them.
>>I used an 860,000 record table to do the test on. Copied out deleted records. Created fresh tags on deleted() and Ctrlno. Tests running through Win98 even the FoxPro DOS test. Average time of 100 selects.
>>Select statement used:
>>select * from CHECKS where CTRLNO = "86112378" into cursor csrTEMP
>>
>>FoxPro DOS 2.6
>>set deleted on: 0.08 set deleted off: 0.06
>>not bad.
>>
>>Visual Foxpro 5.0a
>>set deleted on: 3.50 set deleted off: 0.06
>>oh my!
>>
>>Here is the interesting one. I removed the tag on deleted() and deleted 5000 records in the table.
>>Visual Foxpro 5.0a
>>set deleted on: 0.05 set deleted off: 0.04
>>Huh??
>>
>>Anyone have any clues, suggestions, comments, or anything???
>>
>>-Michael M. Emmons
>>
*snip