Hi,
so I modified a code to use hotshot module, basically I added
profiler = hotshot.Profile(profile.dat)
profiler.run(loadTables(tableNames))
profiler.close()
to my code instead of just calling loadTables function. Results are
below. I played with code a little bit and it seems to me that most
Below, you can see that establishing the database connection itself to
oracle is taking 1.8 seconds (connect() on the SQLA side). And a huge
2.9 seconds to fetch just 25 rows from your Oracle database
(_fetchone_impl on the SQLA side, which calls cursor.fetchone(), a
cx_oracle native