I have a VFP3 DBC that contains a few tables and a couple of views. Normally the views
work very fast. However, I wrote a small prg that SCANs through a table, grabs a part number,
and issues a =REQUERY() on a view. This works, but in quite a few spots, VFP slows
down quite a bit and just beats on the hard drive. For example, VFP will report 30 records
found in .44 sec, then 20 records found in 50 sec then 25 in .55, ect....

Through out this prg, the hard drive is being beaten on. So what I did is tried the exact
same program in VFP5. The program runs great in VFP5 and I can't even notice the drive
being hit at all. So I tried the SYS(3054, 11) in VFP5 and it reports that the view is fully optimized.

I also modified the program and ran it in FPW26 by generating a cursor and the program just flies
and the hard drive hits are not even noticeable.

Does anybody know why VFP3 hits the drive so much while VFP5 and FPW26 doesn't?

I'm running on a P166 with Win95.

Thanks,

Jerryt