[issue13299] namedtuple row factory for sqlite3

Glenn Langford report at bugs.python.org
Fri May 16 14:32:42 CEST 2014


Glenn Langford added the comment:

In abstract, I like the namedtuple interface for sqlite3 as well. One caution is that the approach suggested at

http://peter-hoffmann.com/2010/python-sqlite-namedtuple-factory.html 

can have a dramatic impact on performance. For one DB-intensive application, I experienced 20+ seconds run time with the row factory (under 3.4), versus sub second without (identified with cProfile). Many thousands of calls to namedtuple_factory were not good. :)

----------
nosy: +glangford

_______________________________________
Python tracker <report at bugs.python.org>
<http://bugs.python.org/issue13299>
_______________________________________


More information about the Python-bugs-list mailing list