Re: Search across multiple sources

> On Sun, 1 Feb 2004, Merrall, Graeme wrote:
>
> >
> > I don't think there's an easy way to do this but I thought
> I better ask just in case. I'm trying to come up with a way
> to search across a number of databases without resorting to
> lots of horrible scripts. In one database I have a lot of
> news stories from our news provider while in another database
> I have a lot of user entered content. Ideally I'd like to
> search across both databases via a single web-based search form.
> >
> > The obvious way is to create a tsearch index/table in both
> databases and then to connect to each one in turn and to
> merge the results together but that doesn't seem like the
> best solution and potentially there could be issues with
> ranking and so on.
> >
> > Is it possible to create a single search database which can
> store search data from a number of different databases. This
> is all on the same server of course.
> >
> > Another option I looked at was to use an external search
> tool lke mnogosearch
> (http://www.mnogosearch.ru/doc/msearch-extended-indexing.html#
htdb) although since I've used tsearch elsewhere it would be nice to use
it here as well.
>
>
> Why not use schema and single search table contains indices from
> different schemes (use trigger to update search table)

Thanks for the reply Oleg. I looked at using schema snd I'm not entirely
sure whether I want to go the schema route at this stage although if
that's my only option I'm more than happy to consider it. I'm giving it
some serious thought though.

Cheers,
Graeme