Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Invalid Seek Offset - reproducible
Message
 
 
À
21/07/2006 12:26:23
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:
01138584
Vues:
13
>I have the impression that the indexes get corrupt by a sequence of actions
>
>A couple of things are worth trying
>
>(1) limit the cache
>
>=sys(3050,1, 64 * 1024 * 1024)
>=sys(3050,2, 16 * 1024 * 1024)
>
>
>(2) after every insert/update
>
>flush
>=sys(1104)
>
>
>(3) go top, then seek
>
>
>You'll quickly find out whether the above helps

We're working on buffered data, so I'm not sure 2) will help. I also just found very weird indexes in all stage tables (alltrim(upper(field)) with a filter.

I'm clearing up indexes in stage tables right now, then I resume my tests.
If it's not broken, fix it until it is.


My Blog
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform