I seem to be having a bit of trouble with MySQLdb queries taking a lot longer than the same query in the 'mysql' client program. I've tried using the SSCursor (server side), but that just makes MySQLdb crash, either with a Segmentation fault, or a Python assertion error (!).
The query is not all that large (50k rows, 2-300 bytes per row). In the mysql client, it returns in 17 seconds. The exact same query using MySQLdb takes 33 (!) seconds to return from cursor.execute(query). Does anyone know why this might be happening?
Using Python 2.1.3 and the current stable MySQLdb.
Freddie
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hi,
I seem to be having a bit of trouble with MySQLdb queries taking a lot longer than the same query in the 'mysql' client program. I've tried using the SSCursor (server side), but that just makes MySQLdb crash, either with a Segmentation fault, or a Python assertion error (!).
The query is not all that large (50k rows, 2-300 bytes per row). In the mysql client, it returns in 17 seconds. The exact same query using MySQLdb takes 33 (!) seconds to return from cursor.execute(query). Does anyone know why this might be happening?
Using Python 2.1.3 and the current stable MySQLdb.
Freddie