[sqlalchemy] Help understanding database round trips

2013-03-26 Thread Laurence Rowe
I'd like to measure the number of database round trips that are associated with a request to my web application so I can write tests to catch potential performance regressions. I've been using mock.Mock(wraps=connection.execute) to keep count and while I think this works for selects, I don't

Re: [sqlalchemy] Help understanding database round trips

2013-03-26 Thread Michael Bayer
On Mar 26, 2013, at 5:24 PM, Laurence Rowe laurencer...@gmail.com wrote: I'd like to measure the number of database round trips that are associated with a request to my web application so I can write tests to catch potential performance regressions. I've been using

Re: [sqlalchemy] Help understanding database round trips

2013-03-26 Thread Laurence Rowe
On Tuesday, 26 March 2013 14:54:08 UTC-7, Michael Bayer wrote: On Mar 26, 2013, at 5:24 PM, Laurence Rowe lauren...@gmail.comjavascript: wrote: I'd like to measure the number of database round trips that are associated with a request to my web application so I can write tests to

Re: [sqlalchemy] Help understanding database round trips

2013-03-26 Thread Michael Bayer
On Mar 26, 2013, at 6:41 PM, Laurence Rowe laurencer...@gmail.com wrote: Thanks, moving to a connection event seems like a cleaner way to measure this than the mock. When using the ORM, does SA always fetch any db generated primary key? It only does this if it doesn't have the primary