>>>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.
In his initial post, Dmitry wrote that the DBF is included in the exe, and later he realized that no index file is used or associated with the DBF. And, the exe is installed and accessed on the network.
I think Chen's SetFilePointer API example is closer to the truth in this case, however, I also think that the the error has to do with the loading of the targeted chunk of the exe. It would not surprise me to eventually realize that the error occurs randomly (and not only when accessing the meta dbf), and that it is caused by micro-drops in network connectivity.
*
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only