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: 443

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

Related posts about full-text-search