[Yum-devel] quick & dirty pysqlite2 experiments
Paul Nasrat
pnasrat at redhat.com
Tue Apr 18 14:44:35 UTC 2006
On Thu, 2006-02-09 at 01:07 +0200, Pekka Pietikainen wrote:
> After being dared to submit patches on #fedora-devel I decided to quickly
> do just that. These patches will eat your dog etc. and need quite a bit of
> thought, but just to get some ideas out...
I want to look to see if we can get some of the improvements here. What
version of pysqlite did you do the testing with?
> TODO: (at least)
>
> - Check all the select statements. In general no sql escaping needs to be done
> manually, just use ? in the SQL and give a tuple of parameters to the
> execute.
>
> - For mass inserts, executemany() could be worth a try. Something like:
Looks interesting.
> (didn't seem to make things much faster, maybe 14.5 vs. 15 secs for a 4000
> package insert, I didn't convert all of the code though.
>
> - Just make the db2class stuff a row factory, and drop that hacky foo-class :D
That would be really nice.
> All in all, an upgrade should allow for cleaner and faster code, but it
> will require some work and probably refactoring too.
Are you still interested in helping out on this?
Paul
More information about the Yum-devel
mailing list