Sample Header Ad - 728x90

SQL Server vs SOLR (Or any document db)

1 vote
2 answers
854 views
I have my "customer" data in a normalized sql server database. Getting out the customer data in my app is taking too long. This is because I have to go to 10+ tables to get all the data I need. My company has an installation of SOLR that I thought about storing a Json object that contains all the data I need for a single "customer" already put together. I think that this would give me some significant speed improvements. However, it got me to wondering what the difference would be to me putting this data in a single table with a varchar(max) column that has the Json in it. I could index my 10ish searchable columns on the same table as the json. I know that document databases are very popular. **So I imagine there has to be benefits over just rolling my own using denormalized data in sql server. Can someone tell me what they are?**
Asked by Vaccano (2550 rep)
Apr 7, 2015, 10:10 PM
Last activity: Feb 8, 2016, 04:08 PM