11 Feb
2012
11 Feb
'12
11:03 p.m.
On 2/11/2012 3:58 PM, Marcello Perathoner wrote:
On 02/11/2012 11:30 PM, Lee Passey wrote:
How does your search algorithm work against the database? I've always thought that full text searches (full text of the metadata, not full text of the pg e-text) were quite inefficient. Do you generate an ad-hoc SQL query every time someone does a search?
One text search column in the books table is enough. You fill that with all metadata you have about the book.
So, select etextid from books where upper(metadata) like '%SEARCH-TERM%'; ??