Just compiled sphinx, the mysql fulltext indexer. Compiling it was a breeze. And when i was stuck at a point, the original developer ( Andrew Aksyonoff, shodan [at] shodan.ru ) helped me out.
Must say OSS makes the world a better place to live in, Red Hat notwithstanding ;-)
Okay on sphinx, i indexed my table which had close to 700,000 rows of data (Blob), and it indexed it in under 100 secs!!. The provided api is good too (PHP and perl at the moment). But one thing it lacks, which i think should be there to make it a worthy replacement to mysql fulltext indexing itself is that you can not say +findme -leaveme in a search query.
Nevertheless it did show pretty neat results and it is one utility to watch out for. For more info visit: www.shodan.ru/projects/sphinx/
Wednesday, November 23, 2005
Subscribe to:
Post Comments
(
Atom
)
1 comment :
Hi,
But I have heard that Mysql is "the Fast" database.. and after going to its 5th version you can need imporve its search from thrid party software. Is that mean Mysql is not that mature itself yet.
Post a Comment