>Hello everyone,
>
>I have a very frustating problem with a process that I am adding to an existing application. I am adding a 'refresh' process for a customer to update data in a table of approximately 4,000,000 records. At this point it is about as simple as it can be: (1) Scan the 'new' file, (2) Seek the record in the old file, (3) Update as necessary. It will run to completion on my local machine (after 10-12 hours), but at the customer site on their server it runs for an hour or two and we get the "Internal Consistency Error". This is VFP8 and table buffering is turned off. I realize that this may be an impossible question to answer, but I will be happy to give more info to anyone who needs it, and maybe if you could tell me your experiences with this error and what was causing it for you, that may help.

- it might run better/faster if the data are local (not on a network drive) (if not already)
- make sure you're running VFP8 SP1 to take advantage of bug fixes
- you could try calling SYS(1104) periodically in the process
- if you're processing GB+ files try to make sure the computer has lots of RAM - the more the better, anything less than 512MB will likely thrash the disk through the pagefile and VFP disk buffering
- hopefully you're running it on W2K/XP/2003 not 98/Me
- make sure any running AV process is set to not scan or attempt to scan VFP-related files (.DBF, .CDX, .FPT, .TMP for cursors etc.)