3 ms·
The interesting question is why the ODBC driver needed to be updated and why it was such a hurry. Probably because he/she wanted to see if it worked before busi
by z3t4 7y ago
The interesting question is why the ODBC driver needed to be updated and why it was such a hurry. Probably because he/she wanted to see if it worked before business opening... And when he/she was not allow to do that maintenance on off hours, then he/she tested it on a less important internal system.
The thing with ODBC drivers is that they deal with things like bigin support, which cover edge cases that you only see in production.
- rachelbythebay 7y agoODBC was not used anywhere prior to this point. The company had its own hardened transports. The frontend systems, taken as a whole, amounted to a bitchin’ botnet. They’d destroy ordinary services without even working up a sweat. Using the right mechanisms for comms between them was in everyone’s best interest.
- asdfasgasdgasdg 7y agoOdbc/SQL newb. I know what begin does, but I don't know why you'd only see it in prod. Surely you should test the same codepaths in staging that you plan to execute in prod?
- NikolaeVarius 7y agoGenerally speaking from experience, most non-production facing testing does not accurately reflect what is actually happening in production in terms of actual queries run and volume of it. A codepath which is perfectly fine in testing/staging could kneel over immediately against a production workload,
- mbreese 7y ago"Quantity has a quality all its own." - Someone (I heard it attributed to Napoleon, but have seen it attributed to others) In this case, it's very true -- workloads are really difficult to properly test with respect to production load. A code path that works well in one test can easily buckle under the pressure of a production workload. Stress testing is hard.
- asdfasgasdgasdg 7y agoThat's all well and good, but begin is pretty basic? Like, that's how you do transactions in SQL, right? We're not talking about a codepath that's working in testing and falling over in production. The person I responded to was suggesting a codepath that's not even tested in testing, and I was hoping to understand why begin would be such a codepath.