>>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.

Yes.. its also true....