Sqlite3. Substitution of names in query.
Lawrence D'Oliveiro
ldo at geek-central.gen.new_zealand
Tue Nov 3 01:59:08 EST 2009
In message <mailman.2504.1257216390.2807.python-list at python.org>, Carsten
Haese wrote:
> With all due respect, but if your experience is exclusive to
> MySQL/MySQLdb, your experience means very little for database
> programming practices in general.
I wonder about the veracity of your claims, because:
> And here are the corresponding results on my laptop:
> $ python -mtimeit -s "from querytest import Tester; t=Tester()"
> 't.with_params()'
> 10000 loops, best of 3: 20.9 usec per loop
> $ python -mtimeit -s "from querytest import Tester; t=Tester()"
> 't.without_params()'
> 10000 loops, best of 3: 36.2 usec per loop
Didn't you say previously that there should be a "seven orders of magnitude"
difference? What happened to that claim?
More information about the Python-list
mailing list