Is Lucern.net good choice for website search of 1M item product database? (giving up on SQL Server

Posted by Pete Alvin on Stack Overflow See other posts from Stack Overflow or by Pete Alvin
Published on 2010-03-11T22:07:09Z Indexed on 2010/03/12 1:37 UTC
Read the original article Hit count: 423

Filed under:

lucene.net

|

full-text-search

|

dtsearch

|

sql-server-2005

|

ASP.NET

We currently have in production SQL Server 2005 and we use it's full text search for a eCommerce site search of a million product database. I've optimized it as much as possible (I think) and we're still seeing search times of five seconds.

(We don't need site scrawl or PDF (etc.) document indexing features... JUST "Google" speed for site search.)

I was going to buy dtSearch but now I realize I can just use Lucerne.net and save the $2,500 for two server license.

I read on a post that Lucerne.Net is not good for website searches.

Has anyone else used Lucerne.Net from ASP.Net? Does it take a lot of memory?

Any problems?

Any comments?

© Stack Overflow or respective owner

Related posts about lucene.net

Good Lucene .NET alternative for ASP.NET website

as seen on Stack Overflow - Search for 'Stack Overflow'
Are there any good alternatives for Lucene .NET to use in a ASP.NET website? I want to index XML-, TXT-, PDF- and DOC-files. Thanks! >>> More
Where does lucene .net cache the search results?

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, I'm trying to figure out where Lucene stores the cached query results, and how it's configured to do so - and how long it caches for. This is for an ASP.NET 3.5 solution. I'm getting this problem: If I run a search and sort the result by a particular product field, it seems to work the very… >>> More
Lucene .Net Searching with TermVector

as seen on Stack Overflow - Search for 'Stack Overflow'
in Lucene.Net,i am creating the document for searching a word and want to display before 10 words and after 10 words.i have used TermVector. Lucene.Net.Documents.Field fldContent = new Lucene.Net.Documents.Field("content", content, Lucene.Net.Documents.Field.Store.YES, Lucene… >>> More
Lucene.Net support phrases?: What is best approach to tokenize comma-delimited data (atomically) in

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a database with a column I wish to index that has comma-delimited names, e.g., User.FullNameList = "Helen Ready, Phil Collins, Brad Paisley" I prefer to tokenize each name atomically (name as a whole searchable entity). What is the best approach for this? Did I miss a simple option to… >>> More
Lucene.NET vs SQL Server Full-text – Generating a million records and a full-text index

as seen on Dot net Slackers - Search for 'Dot net Slackers'
In this article we will take a look at how SQL Server performs with one million records in a table. We will create a quick data pumper program to fill up a table with a million dynamically created rows of data. From there we will take a look at querying the data without any special optimizations… >>> More

Related posts about full-text-search

Error while configuring Sql server 2005 for full text search

as seen on Stack Overflow - Search for 'Stack Overflow'
I am trying to index a table for full text search on a SQL server 2005. When I select the change tracking as Automatic and click on the next button, I get the following error TITLE: Microsoft SQL Server This wizard will close because it encountered the following error: For help,… >>> More
Configuring Sql server 2005 for full text search

as seen on Stack Overflow - Search for 'Stack Overflow'
I am trying to index a table for full text search on a SQL server 2005. When I select the change tracking as Automatic and click on the next button, I get the following error TITLE: Microsoft SQL Server This wizard will close because it encountered the following error: For help,… >>> More
How to customize the full text search ?

as seen on Stack Overflow - Search for 'Stack Overflow'
Full text search is becoming a tedious job using the relational databases’ approach. Can anybody suggest an alternate option if any or way to customize the full text search ? >>> More
WHoosh (full text search) index problem

as seen on Stack Overflow - Search for 'Stack Overflow'
iam having the following problem with whoosh full text search engine. 1.After syncdb i am creating the intial index from the database objects. 2.it is working fine.I can able to search the data and see the results. 3.after that in one of my view i have added another document (via signals) to the… >>> More
How to implement full text search in Django?

as seen on Stack Overflow - Search for 'Stack Overflow'
I would like to implement a search function in a django blogging application. The status quo is that I have a list of strings supplied by the user and the queryset is narrowed down by each string to include only those objects that match the string. See: if request.method == "POST": form… >>> More