Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Performance degrade reply
Message
De
07/04/1998 03:09:19
Vincenzo Longobardi
Cisco Consulting Srl
Rome, Italie
 
 
À
06/04/1998 11:48:04
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00089179
Message ID:
00090071
Vues:
50
Hi Frank,
my little story is that:
this is my open database:
* Usa archivio
USE (XDIR_AZI+"MOVART")
*
* Verifica indici
USE (XDIR_AZI+"MOVART") EXCLUSIVE

INDEX ON DTOS(MADMOV)+STR(MANMOV,5)+STR (MANRIG,3) TAG MOVART1 OF (XDIR_AZI+"MOVART1") FOR .NOT.DELETED()

INDEX ON MATMCOD+MAARCOD1+DTOS(MADMOV)+STR(MANMOV,5)+STR(MANRIG,3) TAG MOVART2 OF (XDIR_AZI+"MOVART1") FOR .NOT.EMPTY(MAARCOD1).AND..NOT.DELETED()

INDEX ON MATMCOD+MATCMTIP+MAARCOD1+DTOS(MADMOV)+STR(MANMOV,5)+STR(MANRIG,3) TAG MOVART3 OF (XDIR_AZI+"MOVART1") FOR .NOT.EMPTY(MAARCOD1).AND..NOT.DELETED()

????Attention???
*********
INDEX ON MATMCOD+MATCMTIP+MAARCOD1+DTOS(MADMOV)+STR(MANMOV,5)+STR(MANRIG,3) TAG MOVART4 OF (XDIR_AZI+"MOVART1") FOR .NOT.EMPTY(MAARCOD1).AND.MAQMOV#MALPREL ***!!!!!this is my index adding***
*********


INDEX ON MATMCOD+MACFX+MACLI+DTOS(MADMOV)+STR(MANMOV,5)+STr(MANRIG,3) +MAARCOD1 TAG MOVART5 OF (XDIR_AZI+"MOVART1") FOR .NOT.EMPTY(MAARCOD1).AND..NOT.EMPTY(MACLI)

USE (XDIR_AZI+"MOVART")

SET INDEX TO (XDIR_AZI+"MOVART1.CDX") ORDER 1
*
* Fine
RETURN

the time of waiting to replace a document of 2000 records
is now 3 minutes befor my index replace that in 1 minute

i hope my english help you to understand
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform