On Fri, Dec 16, 2011 at 15:58, Jon Nelson <jnel...@jamponi.net> wrote:
> Revised to use: > > for row in rows: > dict(row) # throw away result > count += 1 I wonder how this could even work... iterating over the row yields individual values, not tuples?! I wonder what kind of column types you are using. Could you post your code for both your tests (with and without SA)? > SQLAlchemy: 115,000 to 120,000 rows/s (vs. psycopg2 @ 480K - 580K, or > psycopg2 COPY @ 620K). > > I suspect the issue is that I'm only selecting one column, so the > per-row overhead is exaggerated. That is certainly a factor but even then, your numbers seem strange (at least to me). -- Gaëtan de Menten -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com. To unsubscribe from this group, send email to sqlalchemy+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en.