Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Speeding up a lookup with a large character field
Message
De
11/02/2002 18:57:17
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00618638
Message ID:
00618642
Vues:
12
Michelle,

... provided you are on the source table to search...

lfound=INDEXSEEK(whatIwant, .T.)

IF lfound
.... get the file stuff you want... the record pointer has moved there...
ENDIF

See HELP for INDEXSEEK()

HTH

Ric

>I have a cursor that contains every directory on my hard drive. Given a path, I need to find the record. Even taking a chance by limiting the field to 240 characters so I can SEEK instead of LOCATE, it's still unacceptably slow.
>
>I'm wondering if it's possible to make it faster. I thought about making a smaller key field that takes the full path and condenses it into something smaller. There are a couple problems with that, though. First, I don't have any idea how to change the path into something smaller that will still be unique. Second, whatever function does the conversion, plus the SEEK after needs to be faster than just SEEKing on the path.
>
>Anyone have any suggestions?
>
>Thanks,
>
>Michelle
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform