>Same.. but not same...
>Example
>"SP/HP Cable USB mini A-B Camera/Drucker"
>"HP Papier A4 matt Tintenstrahldrucker"
>"DRU Tinte HP Business InkJet 1000 Farbdrucker"
>
>How you thinking "farbdrucker" word will found if I will use separate word?? seems no.. for this case I must use LIKE %drucker% but its not optimized.
>For 300 000 records in table - I have 2 000 000 words... (only one description field indexed) and in any case must use LIKE %value%... then.. prefix "####" seems just one solution...
>
>Another talk - use single word in field.. or description field... I thinking... very big recordcount to separate description to words..
Tough. You could still use the words table with cWord $ words.word, provided the cWord is long enough - or else you'd get too many false hits. It wouldn't make too much sense to search for HP inside words - who knows how many German compound words you may find that you don't need - but I figure anything with at least five characters is worth looking for inside the words.