Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Faster way to search for a word
Message
From
10/06/2008 14:47:10
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
 
 
To
10/06/2008 12:56:13
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
01322854
Message ID:
01322881
Views:
13
>what's the fastest way to search for a word?
>
>I use:
>
>SET FILTER TO AT(UPPER('HARDDISK'),UPPER(stockname))=1
>BROWSE
>
>but I think it's too slow
>
>thanks for the help
>
>Jerry

The basic problem is that, with an appropriate index, you can optimize a search on the BEGINNING of a text, but not a search on ANY PART of a text. There are third-party tools that allow you to create separate indices, or you could create them yourself - the idea would be to create a separate, indexed, file that includes every word in the main file. But that is fairly complicated, especially if you want to do it yourself.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
Previous
Reply
Map
View

Click here to load this message in the networking platform