I am still stuck with my full text search engine. I have experemented
with
different approaches to seleting search results and figure out that
having temporary tables is about 300 times faster than doing 'inner
joins'
The table:
+---+--+--+-+-+---+
|
On Thu, Feb 13, 2003 at 03:04:08PM +0300, Artem Koutchine wrote:
homemade fulltext searchsystem
The query is:
SELECT DISTINCT w0.l_id FROM law_words as w0
inner join law_words as w1 on w0.l_id=w1.l_id
inner join law_words as w2 on w0.l_id=w2.l_id
inner join law_words as w3 on
On Thu, Feb 13, 2003 at 05:57:54PM +0300, Artem Koutchine wrote:
The effect is you limit the possible rows to a small amount really
quick
with a simple join. The details of the search are handled bij a like
which
can get as complicated as you like using OR`s, NOT`s etc; it won`t
need