aka…..”when good queries go bad!”
So, today the developers were debugging why a script was running
much longer than expected. They were doing text database inserts,
and got to the point where they realized that double the amount
of text meant the queries took double the amount of time.
You see, they were doing similar text inserts over and over,
instead of using connection pooling and/or batching them.
Apparently the other DBA explained that it was a limitation of
MySQL, but either the developers didn’t convey what they were
doing well, or the DBA didn’t think to mention batching. More »