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)? -tkc -- https://mail.python.org/mailman/listinfo/python-list