Up front, I'm not using the ORM at all, and I'm using SQLAlchemy 0.7.4 with psycopg2 2.4.3 on PostgreSQL 8.4.10 on Linux x86_64.
I did some performance testing. Selecting 75 million rows (a straight up SELECT colA from tableA) from a 5GB table yielded some interesting results. psycopg2 averaged between 485,000 and 585,000 rows per second. Using COPY (via psycopg2) the average was right around 585,000. sqlalchemy averaged between 160,000 and 190,000 rows per second. That's a pretty big difference. I briefly looked into what the cause could be, but I didn't see anything jump out at me (except RowProxy, maybe). Thoughts? PS - is the OrderedDict implementation in 2.6+ faster or slower than the one SA ships with? -- Strange things are afoot at the Circle K. Jon -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en.
