Fulltext search is painfully slow

[GoogleCodeExporter]

Currently we use a construct like "like %str%" to do a fulltext search on the 
name field in the shares table which makes it awfully slow.

We should either implement the db engine specific match function or think about 
creating an index for fulltext search. Since sqlalchemy does not provide us 
with a generic interface to do a match clause and some db engines do not even 
support fulltext search I suggest implementing a seperate index for it. One 
solution might be to utilize Whoosh 
(https://bitbucket.org/mchaput/whoosh/wiki/Home).

Original issue reported on code.google.com by hbwint...@gmail.com on 5 Aug 2011 at 8:52

• Blocked on: Performance tweaks for the search #37