> > we did some testing where a client was seeing 4k+ TPS *shrug*
>
> So, is one select statement equal to one of these transactions? Seems to
me
> that talking about transactions per second is like talking about
instructions
> per second on a complex instruction-set CPU - depending what you use
> for an instruction, your answer could vary significantly.
Just reading this discussion it sounds to me like empty transactions (ie. a
bunch of BEGIN; COMMIT;). Which is a good measure of transaction overhead,
but not necessarily real world performance.
Greg