Sqlite3. Substitution of names in query.

Lawrence D'Oliveiro ldo at geek-central.gen.new_zealand
Tue Nov 3 07:59:08 CET 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