Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Index corrupted
Message
De
09/06/2021 13:07:14
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Divers
Thread ID:
01681084
Message ID:
01681108
Vues:
47
Sanity check first: table, cdx (plus fpt if it exists) exempted from virus and other scans ?
SSD, HD or SSD assisted HD ? Any DDR cache RAM on this disk ?
Tried with specific small dedicated SSD for that table alone ?
Tried with a RAM disk for that table ?

Access/usage pattern of that table C/S ready ?
no direct or tablebuffered use only cursoradapter, remote view or SQL handling meant ?
Can you describe "typical" R/W access pattern of table (continous access across vs. long idle then large bursts ?)

I would not totally rule out SMBx problems if the apps ran under different user accounts...

regards
thomas

>I have a customer where the cdx file continues to be corrupted.... I rebuild indexes (i use for this operation an old version of Stonefield Database Toolkit) and after a few time (even 3 times in same morning) i have to rebuild it..... Table's size is 450Mb and in the cdx files i have 35 tags. We works in rdp session on a server with Windows Server 2012 R2 and 32Gb ram. (this is a phisical machine). The users are using my app are from 6 to 10 and this is the table that probably is used by all the users (both for write and read access)......... Someone has had similar problems ? Some suggests.... This customer uses my app since 2005 and we never have had this problem and the table thta now has problems was in some periods larger (near foxpro limits) and we have moved data to another table....
>
>Thanks
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform