|
Home > Archive > FoxPro database connector > March 2006 > Index corruption problems
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Index corruption problems
|
|
| kanisrufus@yahoo.com 2006-03-06, 7:31 pm |
| 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 2006-03-07, 8:25 pm |
| 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.
<kanisrufus@yahoo.com> wrote in message
news:1141434237.517727.309540@z34g2000cwc.googlegroups.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
>
|
|
|
|
|