Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Speeding up a lookup with a large character field
Message
From
12/02/2002 14:41:26
 
 
To
11/02/2002 18:57:17
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00618638
Message ID:
00619039
Views:
10
The INDEXSEEK managed to speed it enough that I might be able to get away with not hashing the index. I'll keep Gregory's code around, though, just in case.

Thanks, both of you,

Michelle


>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
Previous
Reply
Map
View

Click here to load this message in the networking platform