Interesting criticism against SQLAlchemy

December 30, 2007 § Leave a comment

The Hand of FuManchu pits SQLAlchemy against Storm and Geniusql under his benchmarks.

In the INSERT benchmark FuManchu(I believe he is involved with CherryPy) claims that SQLAlchemy is making over 400 function calls.

FuManchu show these 2 findings on his benchmarks:

  • SQLAlchemy spends a lot of time building the bound parameters.
  • He also claims that SQLAlchemy takes 73 Python function calls fetching auto-increment id.

In response, Mike Bayer wrote, in his blog, saying that SQLAlchemy aims to be a complete ORM with rich features. He even corrected the benchmarks here.

What does this benchmarks mean to me? Nothing much really. I like using SQLAlchemy, it has a lot of features I need and some more. IF this benchmark is right, I can always use raw SQL just for the sake of speed, although such code is ugly.

For readers, read the blogs comments as well. They are very interesting.

About these ads

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

What’s this?

You are currently reading Interesting criticism against SQLAlchemy at RAPD.

meta

Follow

Get every new post delivered to your Inbox.

%d bloggers like this: