On Fri, 25 Sep 2009 10:36:29 -0700 (PDT), Jason Allen <[email protected]> wrote: > Comparing search features available with SQL Server vs. Lucene, do you > have a preference? I'll need not only text based search, but column to > column search as well.
It really depends on your needs. If you want to take some load off your database then a separate search engine is probably better, will likely perform faster, and probably offers more options in the long run, but I'm 100% ignorant of any new whiz-bang search stuff they may have added to SQL 2008. Of course the other consideration is updating your search index if you're using it to index database records. If you need literally up to the second search results, then the DB is your obvious choice. -- Matthew Woodward [email protected] http://mpwoodward.posterous.com identi.ca/Twitter: @mpwoodward Please do not send me proprietary file formats such as Word, PowerPoint, etc. as attachments. http://www.gnu.org/philosophy/no-word-attachments.html --~--~---------~--~----~------------~-------~--~----~ Open BlueDragon Public Mailing List http://groups.google.com/group/openbd?hl=en official site @ http://www.openbluedragon.org/ !! save a network - trim replies before posting !! -~----------~----~----~----~------~----~------~--~---
