3 ms·
#2, so much #2. And also #3. One of my earliest and still one of my favorite career achievements was optimizing a stored procedure in Oracle. Our application
by mulmen 6y ago
#2, so much #2. And also #3.
One of my earliest and still one of my favorite career achievements was optimizing a stored procedure in Oracle. Our application called the procedure and depending on the result dropped a character from the input and called the procedure again.
This was the highest load on our database. We were negotiating a new license to scale up the Oracle database. Estimates were in the six figure range.
I simply reproduced that modification/retry logic inside the procedure. The application always got the desired result on the first call over the network. No application side code change needed at all.
IIRC my optimization reduced load by ~an order of magnitude. We no longer needed the additional Oracle capacity. Saved a multiple of my salary in an afternoon, just looking for a hot spot. I think my boss bought me a sandwich. It was a good day.