Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Google-like queries in FoxPro apps
Message
From
16/05/2002 18:38:28
Rick Graves
Advanced Approach Ltd.
Hong Kong, Hong Kong
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00624182
Message ID:
00657860
Views:
26
Steve,

>* Side note.
>Can anyone say that a SQL-Select Where cData="string%" is any slower than >EXACT=OFF and SQL-Select Where cData="string" ?

Good question. Sorry I do not know -- I am an SQL beginner. This should not be too difficult to test.

About tacking words onto the end of the string, consider that in some applications, the Google-like search will include both (shorter) character fields and (longer) memo fields. From the memo fields, the index builder would step through the words in the text taking as many of the following words as will fit in the cData field. So you do not even get to think about tacking words onto the end until you come to the end of the memo field.

Perhaps tacking words onto the end does not hurt, but I do not think it helps.

Also, if you use the Google advanced search syntax, "mouse AND frame" would be the same as 'mouse frame' (without the quotes).

I hope this is helpful.

Perhaps one reason that Google like searches are not so common in the FoxPro community is that they do not happen automatically -- some work is involved (as you know). It may be the same for the programmers at Google. If that type of web search was easy, perhaps the Google search engine would not be considered as the best by so many.

Rick
Previous
Reply
Map
View

Click here to load this message in the networking platform