Fastest way to retrieve and write html contents to file

DFS nospam at dfs.com
Tue May 3 13:00:34 EDT 2016


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".





More information about the Python-list mailing list