Performance Problems when selecting HUGE amounts of data from MySQL dbs

[Gabriel Ambuehl]

-----BEGIN PGP SIGNED MESSAGE-----

Hello Skip,

9 Jan 2002, 17:14:06, you wrote:
>     self.db = MySQLdb.Connection(host=self.host,
>                                  user=self.user,
>                                  passwd=self.password,
>                                  db=self.database,
>                                 
> cursorclass=MySQLdb.cursors.DictCursorNW)  

I'm using MySQLdb.cursors.DictCursor but for some reason, then
fetchall() also returns a dictionary (so does the same like
fetchallDict()) and not a tuple!

This probably accounts for a lot of the performance problem...




Best regards,
 Gabriel

-----BEGIN PGP SIGNATURE-----
Version: PGP 6.5i

iQEVAwUBPDx948Za2WpymlDxAQH8hggArSvfzYLaMTKDEAJC952/5ZsQVrQNT6Qu
BdSPvt12yDi+sdnu+baqJGDkeYXOrdxkj2AQ7ItMYHJgsAZw36/FT+Osd7NBmx9y
/+nSD3XE3r9+FFdS6rCPZP+CTiLUZCLKOGjKc6fP2YAw4h+3781iEviImg1vaIwj
0nR0/JDfsVxE+T8ALe0HXlvMEwk17MNHwIvjn/kiJdkDfj90Mkk6s/OgPzXg12aI
u5Bzky32VtiLMsI/5qPMRs5+6COaSVWayK0WhnODa2Uosb73zD8GD41K+gyW08zF
rwZufH0VYTAQ2iqrbyaLLIqe+xnH1mbOLOxrzpncQGipiBZ42AfDkg==
=OM2b
-----END PGP SIGNATURE-----