Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Invalid Seek Offset - reproducible
Message
De
21/07/2006 11:36:13
Dragan Nedeljkovich
Now officially retired
Zrenjanin, Serbia
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP
Database:
Visual FoxPro
Divers
Thread ID:
01137918
Message ID:
01138547
Vues:
19
>>Well, are you postive that you're doing this with new set of indexes? Maybe you should make sure that SDT has gone through the recreation of indexes first, before trying anything else.
>
>I used our utility to Reindex few times. I also tried Repair option. In addition I tried to pack few tables (we have ~200 tables in a database).

The difference between reindex and rebuild of indexes is that the latter doesn't even try to read the tag information from the existing .cdx (and/or .idx) files, because the tag headers may also be damaged. A rebuilder routine keeps that information elsewhere (mine keeps them hardcoded in a generated routine), destroys the cdx files and builds them from scratch.

With a reindex, there's a chance that some of the tag headers may be just sufficiently damaged to cause problems, and still not damaged enough so the reindex proceed - with unpredictable results. The chances for this are very slim, of course, but you seem to be the statistical anomaly... how many times was it that you were hit by a problem nobody else has ever had?

Mmmm... wasn't there a story from Arkadiy and Boris Strugatsky about a man who was a statistical anomaly?

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