Skip navigation links

MySQL Forums :: Connector/Python :: MySQL Connector/Python vs MySQLdb with DBUtils.PooledDB


Advanced Search

MySQL Connector/Python vs MySQLdb with DBUtils.PooledDB
Posted by: Normann Koldrack ()
Date: September 23, 2012 12:12PM

Hi,

I did some very simple benchmarks with MySQL Connector/Python, MySQLdb and DBUtils.PooledDB.

1000 selects (1 thread)

Connector + pool : 20,9 sec
MySQLdb + pool : 4,0 sec
Connector : 13,3 sec (new connection every time)
Connector : 2,4 sec (same cursor)
Connector : 4,8 sec (same connection)

13,3 sec with new connections every time, but 20,9 sec with a pool?
How is this possible? Is it normal? Why is MySQLdb + pool 5 times faster?

Options: ReplyQuote


Subject Written By Posted
MySQL Connector/Python vs MySQLdb with DBUtils.PooledDB Normann Koldrack 09/23/2012 12:12PM
Re: MySQL Connector/Python vs MySQLdb with DBUtils.PooledDB Geert Vanderkelen 09/25/2012 04:40AM
Re: MySQL Connector/Python vs MySQLdb with DBUtils.PooledDB Normann Koldrack 09/25/2012 09:48AM
Re: MySQL Connector/Python vs MySQLdb with DBUtils.PooledDB Normann Koldrack 10/02/2012 02:46PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.