General information
Category:
Coding, syntax & commands
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only