I'm using lucene in my project. Here is my question: should I use lucene to replace the whole search module which has been implemented with sql using a large number of like statement and accurate search by id or sth, or should I just use lucene in fuzzy search(i mean full text search)?
我在我的项目中使用lucene。这是我的问题:我应该使用lucene来替换整个搜索模块,该模块已经使用大量的类似语句和id或sth的精确搜索来实现,或者我应该在模糊搜索中使用lucene(我的意思是全文)搜索)?
3 个解决方案
#1
3
Probably you should use lucene, unless the SQL search is very performant.
可能你应该使用lucene,除非SQL搜索非常高效。
We are right now moving to Solr (based on Lucene) because our search queries are inherently slow, and cannot be sped up with our database.... If you have reasonably large tables, your search queries will start to get really slow unless the DB has some kind of highly optimized free text search mechanisms.
我们现在正在转向Solr(基于Lucene),因为我们的搜索查询本质上很慢,并且无法加速我们的数据库....如果你有相当大的表,你的搜索查询将开始变得非常慢,除非DB具有某种高度优化的*文本搜索机制。
Thus, let Lucene do what it does best....
因此,让Lucene尽其所能......
#2
0
I don't think using like statement abusively is a good idea. And I believe the performance of lucene will be better than database.
我不认为滥用这种说法是个好主意。而且我相信lucene的性能会优于数据库。
#3
0
I'm actually very impressed by Solr, at work we were looking for a replacement for our Google Mini (it's woefully inadequate for any serious site search) and were expecting something that would take a while to implement. Within 30 minutes of installing Solr we had done what we had expected to take at least a few days and provided us with a far more powerful search interface than we had before.
我对Solr印象非常深刻,在工作中我们正在寻找替代我们的Google Mini(它对于任何严肃的网站搜索来说都是不合适的)并期待一些需要一段时间才能实现的东西。在安装Solr的30分钟内,我们已经完成了我们预期至少需要几天的工作,并为我们提供了比以前更强大的搜索界面。
You could probably use Solr to do quite a lot of clever things beyond a simple site search.
除了简单的站点搜索之外,你可以使用Solr做很多聪明的事情。
#1
3
Probably you should use lucene, unless the SQL search is very performant.
可能你应该使用lucene,除非SQL搜索非常高效。
We are right now moving to Solr (based on Lucene) because our search queries are inherently slow, and cannot be sped up with our database.... If you have reasonably large tables, your search queries will start to get really slow unless the DB has some kind of highly optimized free text search mechanisms.
我们现在正在转向Solr(基于Lucene),因为我们的搜索查询本质上很慢,并且无法加速我们的数据库....如果你有相当大的表,你的搜索查询将开始变得非常慢,除非DB具有某种高度优化的*文本搜索机制。
Thus, let Lucene do what it does best....
因此,让Lucene尽其所能......
#2
0
I don't think using like statement abusively is a good idea. And I believe the performance of lucene will be better than database.
我不认为滥用这种说法是个好主意。而且我相信lucene的性能会优于数据库。
#3
0
I'm actually very impressed by Solr, at work we were looking for a replacement for our Google Mini (it's woefully inadequate for any serious site search) and were expecting something that would take a while to implement. Within 30 minutes of installing Solr we had done what we had expected to take at least a few days and provided us with a far more powerful search interface than we had before.
我对Solr印象非常深刻,在工作中我们正在寻找替代我们的Google Mini(它对于任何严肃的网站搜索来说都是不合适的)并期待一些需要一段时间才能实现的东西。在安装Solr的30分钟内,我们已经完成了我们预期至少需要几天的工作,并为我们提供了比以前更强大的搜索界面。
You could probably use Solr to do quite a lot of clever things beyond a simple site search.
除了简单的站点搜索之外,你可以使用Solr做很多聪明的事情。