On 2016-05-03 13:00, DFS wrote: > On 5/3/2016 11:28 AM, Tim Chase wrote: > > On 2016-05-03 00:24, DFS wrote: > >> One small comparison I was able to make was VBA vs python/pyodbc > >> to summarize an Access database. Not quite a fair test, but > >> interesting nonetheless. > >> > >> Access 2003 file > >> Access 2003 VBA code > >> Time: 0.18 seconds > >> > >> same Access 2003 file > >> 32-bit python 2.7.11 + 32-bit pyodbc 3.0.6 > >> Time: 0.49 seconds > > > > Curious whether you're forcing Access VBA to talk over ODBC or > > whether Access is using native access/file-handling (and thus > > bypassing the ODBC overhead)? > > The latter, which is why I said "not quite a fair test".
Can you try the same tests, getting Access/VBA to use ODBC instead to see how much overhead ODBC entails? -tkc -- https://mail.python.org/mailman/listinfo/python-list
