Tell me more ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
up vote 0 down vote favorite

I need a strong argument as to which one is better and why. Can anyone help me out with this research.

share|improve this question
Pros/cons for each. Better to start with what you want to achieve with a full text solution? – Mark Storey-Smith Jun 12 '12 at 23:30
Currently I am planning to compare the search time needed in both cases with a set of a million records. One drawback i see with solr is takes a while to index million products, well not solr but for us to tell solr to index million products. – tmjam Jun 12 '12 at 23:33
Add some detail to your question explaining the data and type of searches you want to carry out i.e. is it keyword, semantic, faceted? – Mark Storey-Smith Jun 12 '12 at 23:38
Most probably Keyword and faceted. I understand that Solr would be a better option for faceted type of searches, but not difficult to do in sql as well. Sir Can put more light on the performance advantages between those? – tmjam Jun 12 '12 at 23:43
1  
Without some work, this question isn't constructive and needs to be closed – Jack Douglas♦ Oct 16 '12 at 13:30

closed as not constructive by Jack Douglas♦ Oct 16 '12 at 13:30

As it currently stands, this question is not a good fit for our Q&A format. We expect answers to be supported by facts, references, or specific expertise, but this question will likely solicit debate, arguments, polling, or extended discussion. If you feel that this question can be improved and possibly reopened, see the FAQ for guidance.