I am looking to create a search engine that will be based on 5 columns in a SQL 2000 DB. I have looked into Lucene.NET and read the documentation on it, but wondering if anyone has any previous experience with this?
我希望创建一个基于SQL 2000 DB中5列的搜索引擎。我已经查看了Lucene.NET并阅读了它的文档,但想知道是否有人之前有这方面的经验?
Thanks
4 个解决方案
#1
2
IMHO it's not so much about performance, but about maintainability. In order to index your content using Lucene.NET you'll have to create some mechanism (service of triggered) which will add new rows (and remove deleted rows) from the Lucene index.
恕我直言,这不是关于性能,而是关于可维护性。为了使用Lucene.NET索引您的内容,您必须创建一些机制(触发服务),它将从Lucene索引中添加新行(并删除已删除的行)。
From a beginner's perspective I think it's probably easier to use the SQL Server built-in full text search engine.
从初学者的角度来看,我认为使用SQL Server内置全文搜索引擎可能更容易。
#2
1
i haven't dealt with Lucene yet but a friend of mine has and he said that their performance was 4 to 5 times better with lucene than full text indexing.
我还没有处理过Lucene但是我的一个朋友已经和他说他们的表现比lucene好4到5倍全文索引。
#3
1
Performance better? I think that largely depends on volume and how you expect the data to scale.
表现更好?我认为这在很大程度上取决于数量以及您希望数据如何扩展。
SQL Server Full Text is far superior in my opinion. To get this to work with lucene you will need a process to maintain the index by extracting data from the SQL database.
在我看来,SQL Server全文比较优越。要使其与lucene一起使用,您将需要一个通过从SQL数据库中提取数据来维护索引的过程。
#4
1
You cam either use a Lucene Index or SQL FTS Index. I personally lean toward Lucene from a simplicity standpoint. It is also not a black box. Alot of which solution will work (and they both may work) depnds on query load, data size and data update frequency. Lucene does provide a well worn path to building very scalable search solutions for websites. In the future please include some more information about your problem.
您可以使用Lucene索引或SQL FTS索引。我个人从简单的角度倾向于Lucene。它也不是黑匣子。很多解决方案都可以工作(并且它们都可以工作),这取决于查询负载,数据大小和数据更新频率。 Lucene确实为网站构建非常可扩展的搜索解决方案提供了良好的途径。将来请提供有关您的问题的更多信息。
#1
2
IMHO it's not so much about performance, but about maintainability. In order to index your content using Lucene.NET you'll have to create some mechanism (service of triggered) which will add new rows (and remove deleted rows) from the Lucene index.
恕我直言,这不是关于性能,而是关于可维护性。为了使用Lucene.NET索引您的内容,您必须创建一些机制(触发服务),它将从Lucene索引中添加新行(并删除已删除的行)。
From a beginner's perspective I think it's probably easier to use the SQL Server built-in full text search engine.
从初学者的角度来看,我认为使用SQL Server内置全文搜索引擎可能更容易。
#2
1
i haven't dealt with Lucene yet but a friend of mine has and he said that their performance was 4 to 5 times better with lucene than full text indexing.
我还没有处理过Lucene但是我的一个朋友已经和他说他们的表现比lucene好4到5倍全文索引。
#3
1
Performance better? I think that largely depends on volume and how you expect the data to scale.
表现更好?我认为这在很大程度上取决于数量以及您希望数据如何扩展。
SQL Server Full Text is far superior in my opinion. To get this to work with lucene you will need a process to maintain the index by extracting data from the SQL database.
在我看来,SQL Server全文比较优越。要使其与lucene一起使用,您将需要一个通过从SQL数据库中提取数据来维护索引的过程。
#4
1
You cam either use a Lucene Index or SQL FTS Index. I personally lean toward Lucene from a simplicity standpoint. It is also not a black box. Alot of which solution will work (and they both may work) depnds on query load, data size and data update frequency. Lucene does provide a well worn path to building very scalable search solutions for websites. In the future please include some more information about your problem.
您可以使用Lucene索引或SQL FTS索引。我个人从简单的角度倾向于Lucene。它也不是黑匣子。很多解决方案都可以工作(并且它们都可以工作),这取决于查询负载,数据大小和数据更新频率。 Lucene确实为网站构建非常可扩展的搜索解决方案提供了良好的途径。将来请提供有关您的问题的更多信息。