Both MySQL and Postgre have index searching , yes. I have not tried PostgreSQL FTS but SphinxSearch is renowned for fastest indexing and fastest search. its python api is very easy too, you should give it a try.
http://sphinxsearch.com/ On Sat, Aug 28, 2010 at 3:32 AM, Michele Comitini < michele.comit...@gmail.com> wrote: > 2010/8/27 Phyo Arkar <phyo.arkarl...@gmail.com>: > > Yes i do use forks before in C and Python . > > Forks works well on web2py? > From my experience I would say so. > > > > > what i am doing now is trying to parse any kind of files. well lets say > it > > is a crawler (not and indexer) yet. it crawls and insert into database. > > > > for indexer i already using sphinx. Fastest one ever,from my tests. > > do you use postgresql? if so why not using this? > http://www.postgresql.org/docs/8.4/interactive/textsearch.html > it is fast! >