Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQL LIKE and Rushmore optimization
Message
De
20/01/2006 09:54:55
 
 
À
20/01/2006 09:36:51
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP2
Network:
Windows XP
Database:
Visual FoxPro
Divers
Thread ID:
01088808
Message ID:
01088894
Vues:
26
Ok. I'v seen your messages.. Thats good solution when you finding completed words or first part of word ..

What with "DRUCKER" search for next example? all of this records will out of result cursor...
"SP/HP Cable USB mini A-B Camera/Drucker"
"HP Papier A4 matt Tintenstrahldrucker"
"DRU Tinte HP Business InkJet 1000 Farbdrucker"

And again.. not possible to create optimized expression?
Also.. you put result to "readwrite" cursor.. and requery this cursor.. this query can't use rushmore, because cursor does not indexed....
Just interesting.. you have 2 million records.. can you talk me approx. time of query.. using your alghoritm of search for example.. for 2-3 words in search string.

About phdbase.. I'v seen your and Sergey messages.. sounds bad.. :(

Thank you
Denis.

>>Oh.... %-[ ]
>>but PHDBase currently working in same application for search keywords for memo fields. (we converting pdf documentation and offer fulltextsearch over PHD)... of course.. nobody manually check about results completed..If what you said is true... it sounds realy not good.... PHD was my last idea to solve problem...
>
>See my message to Sergey, message#1088885, and message#1054653.
>
>>>Sorry, but phdBase is discontinued. The last version which was released, 3.61 as fas as I know, is not compatible with VFP8 or VFP9. I used it a lot, but had to give up when it crashed VFP8, gave wrong or incomplete results and so on. I spent several months to try to make workarounds, but gave up.
>>>
>>>
>>>>At this reason.. I try to find common VFP way to solve this task...
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform