Re: Estimating the required volume to

2013-06-03 Thread Mysurf Mail
Hi, Thanks for your answer. I want to refer to your message, because I am trying to choose the right tool. 1. regarding stemming: I am running in ms-sql SELECT * FROM sys.dm_fts_parser ('FORMSOF(INFLECTIONAL,"provide")', 1033, 0, 0) and I receive group_id phrase_id occurrence special_term disp

Re: Estimating the required volume to

2013-06-03 Thread Erick Erickson
Here's a link to various transformations you can do while indexing and searching in Solr: http://wiki.apache.org/solr/AnalyzersTokenizersTokenFilters Consider > stemming > ngrams > WordDelimiterFilterFactory > ASCIIFoldingFilterFactory > phrase queries > boosting > synonyms > blah blah blah You ca

Re: Estimating the required volume to

2013-06-03 Thread Mysurf Mail
Thanks for your answer. Can you please elaborate on "mssql text searching is pretty primitive compared to Solr" (Link or anything) Thanks. On Sun, Jun 2, 2013 at 4:54 PM, Erick Erickson wrote: > 1> Maybe, maybe not. mssql text searching is pretty primitive > compared to Solr, just as Solr's

Re: Estimating the required volume to

2013-06-02 Thread Erick Erickson
1> Maybe, maybe not. mssql text searching is pretty primitive compared to Solr, just as Solr's db-like operations are primitive compared to mssql. They address different use-cases. So, you can store the docs in Solr and not touch your SQL db at all to return the docs. You can store

Estimating the required volume to

2013-06-01 Thread Mysurf Mail
Hi, I am just starting to learn about solr. I want to test it in my env working with ms sql server. I have followed the tutorial and imported some rows to the Solr. Now I have a few noob question regarding the benefits of implementing Solr on a sql environment. 1. As I understand, When I send a