Re: [GENERAL] Searching data across tables, some large

2007-05-23 Thread Robert Fitzpatrick
On Wed, 2007-05-23 at 19:48 -0400, Robert Fitzpatrick wrote: > On Wed, 2007-05-23 at 18:53 -0400, Ericson Smith wrote: > > Yeah, we've used Tsearch with joins and searches on other fields on > > the tsearch table no problem. Tsearches are just another part of a > > WHERE clause. > > > > And can

Re: [GENERAL] Searching data across tables, some large

2007-05-23 Thread Robert Fitzpatrick
On Wed, 2007-05-23 at 18:53 -0400, Ericson Smith wrote: > Yeah, we've used Tsearch with joins and searches on other fields on > the tsearch table no problem. Tsearches are just another part of a > WHERE clause. > And can there be Tsearch fields built based on fields in different tables? Where ca

Re: [GENERAL] Searching data across tables, some large

2007-05-23 Thread Ericson Smith
Yeah, we've used Tsearch with joins and searches on other fields on the tsearch table no problem. Tsearches are just another part of a WHERE clause. Regards - Ericson Smith Developer http://www.funadvice.com On 5/23/07, Robert Fitzpatrick <[EMAIL PROTECTED]> wrote: Thanks to Richard for the he

[GENERAL] Searching data across tables, some large

2007-05-23 Thread Robert Fitzpatrick
Thanks to Richard for the help earlier this week with performance questions, once I was able to get pgsql and mssql using the same resources and doing some tuning, I was able to get comparable results. The issue still though, I have this view that I designed with the thought in mind to provide all