Information générale
Titre:
INDEX ON DELETED??????
I have a very large table containing approximately 5 million entries.
It has always been stated that it is a good practice to create an
index tag on DELETED(). However, when browsing a VFP 5.0
table with this number of records the time to see the results
is Very SLLLLOOOOOWWW.
SQL queries also seem slower unless you SET DELETED OFF.
If that global setting needs to be turned off to get performance
what is the point.
I have heard from one of if not the best FoxPro guru's that
what is taking place is that the bitmap of the deleted tag will
be copied to the users local PC. This truly appears to be the
case when viewing the number of bytes being transfered
across the network.
Anyone else out there dealing with large tables with a deleted
tag? Not sure the best approach. I know that the SYS(3054,11)
function will not return a FULL optimization with an index tag.
Your thoughts on this matter will be appreciated...
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement