Is Lucern.net good choice for website search of 1M item product database? (giving up on SQL Server
- by Pete Alvin
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?