>>I believe Dmitry says there are only 100 rows in this DBF and he says he pulls the whole thing into a cursor.
>>Solution: REMOVE THE INDEX.
>>You really don't need an index or indexes on a table that small. FoxPro will suck the whole table into memory in a heartbeat or two.
Fair enough for a tiny table... though instinctively it's a shame to do away with some of VFP's secret strengths including SEEK() and SET RELATION. ;-)
My pick is that some of the VFP innards date from a time when file access was a yes/no phenomenon so once you get your Yes, you don't want to have to keep checking the obvious when you're after performance. Then OSs and virus scanners etc got clever and began finessing things and every so often somebody fails to Give Way.
"... They ne'er cared for us
yet: suffer us to famish, and their store-houses
crammed with grain; make edicts for usury, to
support usurers; repeal daily any wholesome act
established against the rich, and provide more
piercing statutes daily, to chain up and restrain
the poor. If the wars eat us not up, they will; and
there's all the love they bear us."
-- Shakespeare: Coriolanus, Act 1, scene 1
