I've been benchmarking our software for the last few weeks looking for
bottlenecks, and one of the things that we noticed was that the SSQLS
constructor (given a mysqlpp::Row) was taking a disproportionate amount of
time compared to similar assignment operations. I changed our code to set
the values in the SSQLS one by one using the column index enums instead of
column name strings, and I got a 2x speed improvement overall (working in a
loop with ~40000 iterations, it saved almost 1 second).
Why does the ssqls.pl script use the inefficient operator  (const char*
field) instead of operator  (int i)? The Reference Manual (
specifically warns not to do that. I glanced through ssqls.pl and couldn't
come up with a quick patch, but I'm sure if I had some more time I could fix
it. I'm using 3.0.9.
Thanks for any insight you might have.