[FX.php List] Google-type search across tables?

[Joel Shapiro]

Thanks Webko

I've thought of concatenated fields, but the client wants to search on some "description" fields containing lots of text, and I'm concerned that that might really slow things down.

I was thinking of multiple searches because they'd like the results to be filterable by category.

By "extend that for related tables", do you mean have one concatenated field in the parent table including child fields/records?  Or something else?

Thanks,
-Joel


On Mar 27, 2012, at 4:34 PM, Tim 'Webko' Booth wrote:

> Dear Joel,
>> 
>> Has anybody here implemented a "google-type" search across various fields in multiple tables?  Any thoughts/recommendations?
> 
> I've certainly done it for multiple fields in one table, using a concatenated field.
> 
> I guess you could extend that for related tables, although working out which table actually has the end data might be interesting.
> 
> Or do multiple searches and aggregate the results, which may also allow for a score for relevance - but it would be inefficient due to the overhead involved in each search...
> 
> Just some thoughts
> 
> Webko
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list