Fastest way to retrieve and write html contents to file

Tim Chase python.list at tim.thechases.com
Tue May 3 14:41:21 EDT 2016


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






More information about the Python-list mailing list