Walter Meester
HoogkarspelPays-Bas
Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Network:
Windows 2003 Server
Hi david,
First of all, try to remove that index on deleted(). It probably is only slowing your queries down (Large number of records, only few deleted). That index is absolutely useless in a case you don´t use the COUNT function.
Second, I´ve seen numerous cases where an corruption error was raised, because some obscure unidentified bug in VFP. It was reported in a fresh cursor with an index on it. There was no way this index was corrupted. It was caused by the gui where a grid was involved. I never was able to get a reproducable case to send of to MS.
Walter,
>We continue to get an increasing number of these errors over a period even though the index is not corrupted...
>Error: 2066 - Index file "h:\ht\quids\data\jitems.cdx" is corrupted. Please rebuild it.
>
>The table has approx 2.3 million records has 8 index tags including one on deleted. There are only 200 deleted records. There are large numbers of transactions on this file every day, perhaps 50,000 or so. It's not that huge in terms of disk space, 470MB for the dbf and 95 MB for the CDX.
>
>300 users, and we get perhaps 20 errors per day.
>
>Any ideas folks?
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement