[DB-SIG] Python/PostgreSQL API performance comparison

Gerhard Häring gh at ghaering.de
Mon Jun 2 22:28:24 EDT 2003


Chris Cogdon wrote:
> On Monday, Jun 2, 2003, at 11:49 US/Pacific, Federico Di Gregorio wrote:
> 
>> thank you for the tests,
> 
> 
> You're welcome! I've added as a low-priority ToDo to create a simple 
> framework, including a database schema and some data, so folk can 
> replicate the tests on their own systems and send back changes for 
> additional tests to try. This will include a query that takes very 
> little DMBS processing, (such as a straight table select), as well as 
> one that takes a lot (such as what I've got at the moment). I doubt 
> there'd be any difference in the DB-API performance... but, you never 
> know :)
> 
> It really is low priority for me... but if someone really would like it, 
> I can up the priority with the appropriate encouragements :)
> 
> I'm still happy to take suggestions for changes or additions, though. If 
> they're easy, I'll add them straight in.

It's been on my TODO list as well. Cos without publicly available schema 
*and* test data, such benchmarks are of limited value.

Thanks for your information, though. It's been the first time I've heard 
pyPgSQL having too much overhead in a *real-life* case.

-- Gerhard



More information about the DB-SIG mailing list