Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Performance degrade reply
Message
From
07/04/1998 03:09:19
Vincenzo Longobardi
Cisco Consulting Srl
Rome, Italy
 
 
To
06/04/1998 11:48:04
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00089179
Message ID:
00090071
Views:
49
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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform