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
Original issue reported on code.google.com by
hbwint...@gmail.comon 5 Aug 2011 at 8:52