Index corruption problems

[k***@yahoo.com]

We have recently moved from using VFP 6 to VFP 9 on a host of
applications. Many are batch processes, some form-based and there is
one Web application (using FoxWeb). We created a data-layer based on
extending the cursor adapter and so had to move from VFP6. Now we have
rampant index problems. We have over 400 databases and each one has
more than 100 tables. Some of the tables are close to the 2GB limit but
this is not the issue with the corrupt indexes since smaller tables are
having the same problem.

Set tableupdate is set to 0 - We had a few issues with the validation,
it slowed things down quite a bit and had problems locking the table.
The cursoradapter objects are using Table buffering (Optimistic)
We have updated VirusScanning products to remove the Symantic problem
causing Network Buffered Write failures (LanMan issue)
VFP does not have the current update for VFP 9 - we are still testing

The size of our data is too big to reindex all the time but we cannot
figure out why our indexes seem less stable with 9.

Thanks for any info,
Kanis

[Kanis Rufus]

Also, we have checked the server for logs of issues, made sure network
connectivity is good, etc. We are reviewing log files as well but there
seems to be no real indication of the root problem.

Post by k***@yahoo.com
We have recently moved from using VFP 6 to VFP 9 on a host of
applications. Many are batch processes, some form-based and there is
one Web application (using FoxWeb). We created a data-layer based on
extending the cursor adapter and so had to move from VFP6. Now we have
rampant index problems. We have over 400 databases and each one has
more than 100 tables. Some of the tables are close to the 2GB limit but
this is not the issue with the corrupt indexes since smaller tables are
having the same problem.
Set tableupdate is set to 0 - We had a few issues with the validation,
it slowed things down quite a bit and had problems locking the table.
The cursoradapter objects are using Table buffering (Optimistic)
We have updated VirusScanning products to remove the Symantic problem
causing Network Buffered Write failures (LanMan issue)
VFP does not have the current update for VFP 9 - we are still testing
The size of our data is too big to reindex all the time but we cannot
figure out why our indexes seem less stable with 9.
Thanks for any info,
Kanis