Like I said I am not terribly network savvy but what I meant was that the
particular vpn client that I am using says that my "connection speed" is
~540Mpbs.
I know comparing sql alchemy to raw sql is kind of a no-no but I was just
illustrating that the there isn't obvious evidence of a slow
This is all extremely helpful.
After some hair pulling I was able to get the local sql server express
running and I ran the same test on a local instance.
10100.1260.0000.1260.000 {method 'execute' of
'pyodbc.Cursor' objects}
10100.0600.0000.0600.000
0.015 95.790 95.790
C:\Users\jbrownstein\Documents\GitHub\ETL\ETL\sqlbenchmark.py:60(test_sqlalchemy_orm)
10030.0080.000 94.2510.094
C:\Users\jbrownstein\Documents\GitHub\ETL\ETL\env\lib\site-packages\sqlalchemy\orm\scoping.py:156(do)
30.0030.001 94.059
I've run sqlalchemy on MySQL dbs and never had a problem with performance,
but when I started writing an app that connected to Microsoft SQL Server
2014 via pyodbc I ran into a serious performance problem.
I'm running the app on my laptop and the database server IS in a VPN but my
internet is