4 ms·
Don't use MS SQL server. It has serious issues with locking at scale that you can never get around. Apart from that, just make a choice and run with it.
by debacle 11y ago
Don't use MS SQL server. It has serious issues with locking at scale that you can never get around. Apart from that, just make a choice and run with it.
- GFischer 11y agoAt what kind of scale? I don't think any web application should have problems unless the queries are very badly designed. I've worked with MS SQL for 10+ years (at financial institutions) with no problems. Oracle might be a tad better, but it's also pricier. No idea about Postgre (I've heard it's good), but what you mention shouldn't be a good reason to dismiss MS SQL.
- cakes 11y agoI would also like to know at what scale as I've used MSSQL for several years and only badly designed queries/tables caused locking issues. The real _problem_ (which BizSpark can resolve short-term) seems like it would be licensing.
- richev 11y agoSQL Server scales fine...just ask Stack Exchange. http://nickcraver.com/blog/2013/11/22/what-it-takes-to-run-stack-overflow/ http://nickcraver.com/blog/2013/11/22/what-it-takes-to-run-s...