Oracle Developers
Published in

Oracle Developers

Python-oracledb Thin mode Object performance

Photo by Nicolas Hoizey on Unsplash
$ python objperf.py 
Thin mode: rows=190000 arraysize=1000 roundtrips=199 seconds=2.65

$ DRIVER_TYPE=thick python objperf.py
Thick mode: rows=190000 arraysize=1000 roundtrips=216 seconds=6.02
$ python objperf.py 
Thin mode: rows=3000 arraysize=1000 roundtrips=12 seconds=10.15

$ DRIVER_TYPE=thick python objperf.py
Thick mode: rows=3000 arraysize=1000 roundtrips=29 seconds=19.66

--

--

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Christopher Jones

Oracle Database Product Manager for language drivers including Python python-oracledb, Node.js node-oracledb, PHP OCI8 and more! On Mastodon: @cjbj@phpc.social