News for hackers. Stuff that matters.
Re:My startup is Microsoft-based, here's why by Retric on Monday July 01, 2013 @11:44AM (#5971377)
In our tests NoSQL was far slower than SQL solutions the advantage was it dealt with hardware failures more easily, but if you use 5% as much hardware it's far less of an issue.

Edit: I think one of the largest probmems is most developers doin't understand SQL or databases that well. Indexed Views for example are an incredibly efficient tools that allow you to avoid a lot of expensive joins without the normal risks of denormalizing your data. However, try and think of the last time a developer mentioned them.

Re:My startup is Microsoft-based, here's why by seanc722 on Monday July 01, 2013 @12:36PM (#5971749)
Have any resources that explain Views and the efficiency vs a query..? I thought views had the same performance of the underlying SQL statements.
Re:My startup is Microsoft-based, here's why by Retric on Monday July 01, 2013 @01:27PM (#5972154)
In SQL server normal Views are basically just a select statent but indexed views can have large performance advantages. http://technet.microsoft.com/en-us/library/cc917715.aspx Other DB's have there own optimizations for the same idea.
Re:My startup is Microsoft-based, here's why by jf22 on Monday July 01, 2013 @11:48AM (#5971398)
Sure, but this is a tech agnostic statement. Nothing to do with Microsoft or .net.
Re:My startup is Microsoft-based, here's why by etherael on Monday July 01, 2013 @04:09PM (#5973262)
Last I saw cassandra and pgsql were pretty close to even on single systems, but you can push as many shards in a cassandra cluster as you want. Where are you getting 5% from? Do you mean to imply sql is typically 20x faster than NoSQL on comparable hardware prior to clustering?
Re:My startup is Microsoft-based, here's why by Retric on Monday July 01, 2013 @11:04PM (#5975555)
They provide similar performance where there features overlap but Cassandra is still missing important RDBMS optimizations. A great example being transactions, if you actually need that type of protection it takes a lot more overhead to fake if you don't have DB support. That said I am a believer in mixing both approaches it takes a little more thought and effort, but the benefits can be dramatic.
Re:My startup is Microsoft-based, here's why by etherael on Tuesday July 02, 2013 @01:47AM (#5976070)
I agree with you here, NoSQL can't be used for everything yet, maybe one day, hyperdex + acid looks promising, we'll see. But even restricting the field back to first tier SQL based solutions, you're still talking MS SQL vs PostgreSQL, and the associated licensing fees involved in both scenarios (expensive vs free).

I think performance is pretty similar between the two also last I checked. And you can setup PGSQL with a drbd failover without that much hassle. What are the licensing implications of running two windows servers with an MS SQL server failover? Do you actually need to purchase two copies for that?