When we make a new connection to the database (MySQL in this case), it appears that the dialect has some initialization functions than run several queries:
connection duration rows query primary_slave/tid=9276117 4.014ms 1 'SELECT DATABASE()' primary_slave/tid=9276117 1.868ms 1 "SELECT CAST('test unicode returns' AS CHAR(60)) AS anon_1" primary_slave/tid=9276117 8.586ms 8 "SHOW VARIABLES LIKE 'character_set%'" primary_slave/tid=9276117 4.056ms 1 "SHOW VARIABLES LIKE 'lower_case_table_names'" primary_slave/tid=9276117 8.084ms 126 'SHOW COLLATION' primary_slave/tid=9276117 30.873ms 1 "SHOW VARIABLES LIKE 'sql_mode'" Is there a way to eliminate the need to make these queries ? Though we of course don't open new connections often, it does happen and adding this overhead for information that probably shouldn't change seems unnecessary. (MySQL 5.0.x, sqlalchemy 6.0beta) Rhett -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalch...@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.