Which is both a joke (turning virtue on its head) and kinda true, in that laziness makes you automate things, impatience spurs you to make things faster, and hubris spurs you to make sure that they work.
Which is both a joke (turning virtue on its head) and kinda true, in that laziness makes you automate things, impatience spurs you to make things faster, and hubris spurs you to make sure that they work.
(I'm working right now on a problem my hubris caused me; a variable stored in a database seems to have different values depending on what part of my code it is queried from. Days I've spent trying to understand what's going on...)
Pride also leads us to make our work more robust, so that it "always works well."
Thus, two fundamental principles are respected: optimization and robustness.
Is your problem related to various parts of the code being in distinct transactions? Can you try a version having all parts commiting then immediately synchronizing with each other, then SELECT'ing?