It seems that Baamboo, a very popular music search engine in VN, uses SQL full text search. This discovery makes me pretty surprised since all of the people I know use Lucene as soon as they want to create a search engine. Lucene is very good at what it does. It’s indexing and storage performance is second to none. In fact, it’s so fast that a lot of companies use it as a quick-and-dirty storage dumping ground for raw data, knowing that it will be much faster and more scalable than a relational database. Why not take advantage of this incredible power and take one more item off of your database’s back? This is all not to mention the fact that a Lucene index query is probably a lot faster than an SQL query grabbing data from a Microsoft SQL Server full-text index.
baamboo
baamboo
baamboo
It seems that Baamboo, a very popular music search engine in VN, uses SQL full text search. This discovery makes me pretty surprised since all of the people I know use Lucene as soon as they want to create a search engine. Lucene is very good at what it does. It’s indexing and storage performance is second to none. In fact, it’s so fast that a lot of companies use it as a quick-and-dirty storage dumping ground for raw data, knowing that it will be much faster and more scalable than a relational database. Why not take advantage of this incredible power and take one more item off of your database’s back? This is all not to mention the fact that a Lucene index query is probably a lot faster than an SQL query grabbing data from a Microsoft SQL Server full-text index.