Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Invalid Seek Offset - reproducible
Message
 
 
To
21/07/2006 11:36:13
Dragan Nedeljkovich (Online)
Now officially retired
Zrenjanin, Serbia
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01137918
Message ID:
01138557
Views:
12
The process finished in 6206 sec. or ~2h. No errors this time.

>>>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?
If it's not broken, fix it until it is.


My Blog
Previous
Reply
Map
View

Click here to load this message in the networking platform