[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