Timeline for Is having functionality in DB a road block to scalability?
Current License: CC BY-SA 3.0
9 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Oct 4, 2012 at 8:36 | comment | added | Random42 | The debate here is not about RDSBMS (which provide ACID) vs. various NoSQL which are very scalable but between where the logic should be, in a server or in stored procedures in the database; by using a server for logic (data stored in RDBMS) you do not lose ACID (quite the contrary you have access to more complex transaction APIs). | |
| Oct 3, 2012 at 19:10 | comment | added | Daniel B | That's an interesting point, although I'm not sure consistency was mentioned as a requirement (it could be reporting on financial information originating elsewhere, for example), and the argument was more or less about the validity of "We thought we can gain huge performance boost doing stuff directly in database than through C# code". | |
| Sep 30, 2012 at 15:04 | comment | added | Jim G. | @Blrfl: Right. I'm not suggesting that anyone "go off the deep end" and migrate to a NoSQL solution for a problem like this. | |
| Sep 30, 2012 at 15:03 | comment | added | Jim G. | @Morons: I think we agree. I was in fact conflating the data with "SQL". It's much more expensive to scale the database. | |
| Sep 30, 2012 at 14:52 | comment | added | Blrfl | @JimG.: Software that doesn't scale can be written in any language, including C#. Any database worth its salt can have stored procedures written in languages other than their native SQL-ish implementation, and people who go off the deep end with NoSQL in situations that require ACID usually end up re-inventing most of the wheels that have been nicely implemented by the DBMS. | |
| Sep 30, 2012 at 14:51 | comment | added | Morons | @JimG. Just to clarify, "I can scale the Sql code (not the data) horizontally just as easily as i can horizontally scale the C# code" if it was designed to do so... Same as C# it must be designed to scale. You can't just say C# scales better, it a matter of planning not the language. | |
| Sep 30, 2012 at 14:24 | comment | added | Morons | No its not more scalable, Because that not where the bottle neck is, I can scale the Sql code (not the data) horizontally just as easily as i can horizontally scale the C# code. | |
| Sep 30, 2012 at 14:21 | comment | added | Jim G. | To say that C# performs better than SQL code is also idiocy… - But you're not denying that C# code is more scalable, correct? | |
| Sep 30, 2012 at 14:13 | history | answered | Morons | CC BY-SA 3.0 |