On 13.07.2012 14:22, Tupy... nambá wrote:
> Wenn man die Vorschlage aus Herrn Gödde folgen wird, man kann ein
> "Googler" bauen..... d.h., wenn man "insert" oder "update" macht,
> dann eine Tabelle mit Suchwörte und Index wird aktualiziert......
> stimmt das ?
Genau, but don't forget the "delete" :-)
If this kind of search is needed quite often and search speed is an
issue, it is the easiest solution I can think of. Another approach could
be to add a somehow "normalized" representation of the data
(removing stop-words from customer names, remove letters from VAT-Codes
etc.)
> This can mean that the accessories operations will increase
> the time to insert/update operations.
The impact is not that big from my experience.
We use a similar approach to allow a global search over lot's of
different tables.
fsg
--
"Fascinating creatures, phoenixes, they can carry immensely heavy loads,
their tears have healing powers and they make highly faithful pets."
- J.K. Rowling
