[postgis-users] Search Engine

[Bèrto ëd Sèra]

Hi!


> one should try not to modify database structures just for something like
> text searching.
>

Reality is that very often you cannot modify them (let alone being the db
about GIS or not), because you have poorly documented legacy apps that rely
on them. Or they are decently documented by you don't have the funding it
takes to make the modification. But even if you could, you should NOT. A
good structure has a certain design as a normalization goal. If a given
technology (like text searching) is more efficient when fed denormalized
data, then you make a controlled denormalization, which is usually
maintained by triggers on an EXTERNAL entity (another table).

In the end I have the impression that you and Uli are saying the same thing.

Bèrto

-- 
==============================
Constitution du 24 juin 1793 - Article 35. - Quand le gouvernement viole les
droits du peuple, l'insurrection est, pour le peuple et pour chaque portion
du peuple, le plus sacré des droits et le plus indispensable des devoirs.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20100806/c6be4b14/attachment.html>