gistfile1.txt

vagrant@4a9f4b8ee0f4 /vagrant 
$ python ormtest.py 
SQLAlchemy ORM: Total time for 10 records 1.83095216751 secs
SQLAlchemy ORM bulk save objects: Total time for 10 records 1.7470998764 secs
SQLAlchemy Core: Total time for 10 records 1.82306408882 secs
SQLAlchemy Single: Total time for 10 records 0.45939707756 secs
vagrant@4a9f4b8ee0f4 /vagrant 
$ python ormtest.py 
SQLAlchemy ORM: Total time for 100 records 15.5339519978 secs
SQLAlchemy ORM bulk save objects: Total time for 100 records 15.4684011936 secs
SQLAlchemy Core: Total time for 100 records 15.4472489357 secs
SQLAlchemy Single: Total time for 100 records 0.461940050125 secs
vagrant@4a9f4b8ee0f4 /vagrant 
$ python ormtest.py 
SQLAlchemy ORM: Total time for 200 records 30.7026660442 secs
SQLAlchemy ORM bulk save objects: Total time for 200 records 29.1451561451 secs
SQLAlchemy Core: Total time for 200 records 29.0154681206 secs
SQLAlchemy Single: Total time for 200 records 0.44384098053 secs
vagrant@4a9f4b8ee0f4 /vagrant 
$ python ormtest.py 
SQLAlchemy ORM: Total time for 400 records 58.0110590458 secs
SQLAlchemy ORM bulk save objects: Total time for 400 records 60.6220560074 secs
SQLAlchemy Core: Total time for 400 records 57.9187819958 secs
SQLAlchemy Single: Total time for 400 records 0.442702054977 secs

exception for any of the above for more than 500 entries.

$ python ormtest.py 
SQLAlchemy Single: Total time for 1000 records 0.49683713913 secs
SQLAlchemy Single Params: Total time for 1000 records 0.460470914841 secs
vagrant@4a9f4b8ee0f4 /vagrant 
$ python ormtest.py 
SQLAlchemy Single: Total time for 10000 records 0.842133045197 secs
SQLAlchemy Single Params: Total time for 10000 records 0.902755975723 secs
vagrant@4a9f4b8ee0f4 /vagrant 
$ python ormtest.py 
SQLAlchemy Single: Total time for 100000 records 4.63776087761 secs
SQLAlchemy Single Params: Total time for 100000 records 4.41850090027 secs


same as above with 5 times more data.

vagrant@4a9f4b8ee0f4 /vagrant 
$ python ormtest.py 
SQLAlchemy Single: Total time for 10 records 0.458911895752 secs
SQLAlchemy Single Params: Total time for 10 records 0.443469047546 secs
vagrant@4a9f4b8ee0f4 /vagrant 
$ python ormtest.py 
SQLAlchemy Single: Total time for 1000 records 0.600831985474 secs
SQLAlchemy Single Params: Total time for 1000 records 0.535532951355 secs
vagrant@4a9f4b8ee0f4 /vagrant 
$ python ormtest.py 
SQLAlchemy Single: Total time for 10000 records 1.61409592628 secs
SQLAlchemy Single Params: Total time for 10000 records 1.83351802826 secs
vagrant@4a9f4b8ee0f4 /vagrant 
$ python ormtest.py 
SQLAlchemy Single: Total time for 100000 records 13.9428961277 secs
SQLAlchemy Single Params: Total time for 100000 records 15.52647686 secs