Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Network:
Windows 2000 Server
>Hi all,
>
>I have a web app that relies on VFP data and it runs 24/7. Sometimes, an index entry for a particular record in a table would be corrupt so the code that uses IndexSeek() function cannot find the record. It would be costly for our clients to take the server down to reindex the database frequently.
>
>How do you guys repair the index without taking down the whole system?
>How frequently does this kind of index corruption happen to your data?
>
>Any comments, suggestions will be greatly appreciated.
Hi Dawa,
Could you provide more details about the scenario? Does IndexSeek() fail to find record added/modified by the same client or by some other client? Is the record added/modified recently?
Thanks,
Aleksey.
Précédent
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