Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Extreme slowness caused by missing index tags
Message
De
19/12/2014 03:47:13
Dragan Nedeljkovich (En ligne)
Now officially retired
Zrenjanin, Serbia
 
 
À
18/12/2014 12:11:43
Al Doman (En ligne)
M3 Enterprises Inc.
North Vancouver, Colombie Britannique, Canada
Information générale
Forum:
Visual FoxPro
Catégorie:
Problèmes
Versions des environnements
Visual FoxPro:
VFP 5
OS:
Windows Server 2012
Network:
Windows 2008 Server
Database:
Visual FoxPro
Application:
Web
Divers
Thread ID:
01612388
Message ID:
01612430
Vues:
58
>>I've never seen tags just disappear. Perhaps someone restored an old cdx. LOCATE and SQL will operate without the tags. SEEK won't.
>
>Me neither. Impossible that an old .cdx was restored - there has never been one (until now) that has less than 8 tags. The table is open pretty much 24/7 so restoring an old .cdx or running DELETE TAG etc. would be pretty much impossible.

Just an idea... perhaps the cdx was thoroughly screwed, and the info on all tags was lost. The info on PK is stored in the dbc, so that one was rebuilt. Which mechanism may do this is impossible to know. Don't know whether something would do validation/recover, whether that's covered with table checking on open, whether there's some mechanism in the app (Stonefield?)... just a WAG.

back to same old

the first online autobiography, unfinished by design
What, me reckless? I'm full of recks!
Balkans, eh? Count them.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform