Path: csiph.com!fu-berlin.de!uni-berlin.de!not-for-mail
From: Tim Chase <python.list@tim.thechases.com>
Newsgroups: comp.lang.python
Subject: Re: Fastest way to retrieve and write html contents to file
Date: Tue, 3 May 2016 10:28:50 -0500
Lines: 20
Message-ID: <mailman.352.1462294245.32212.python-list@python.org>
References: <ng6jie$1ap$1@dont-email.me> <85vb2xgj2i.fsf@benfinney.id.au> <mailman.298.1462164614.32212.python-list@python.org> <ng6mn7$8nv$1@dont-email.me> <1462166136.1167243.595273897.291B0865@webmail.messagingengine.com> <mailman.303.1462166138.32212.python-list@python.org> <ng6q67$gnm$1@dont-email.me> <1462170452.1180117.595306673.68B64F02@webmail.messagingengine.com> <mailman.308.1462170455.32212.python-list@python.org> <ng6vsl$1jc$1@dont-email.me> <572823D8.6050204@gmail.com> <mailman.335.1462248430.32212.python-list@python.org> <ng98um$hjh$1@dont-email.me> <20160503102850.63cec18a@bigbox.christie.dr>
Mime-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit
X-Trace: news.uni-berlin.de 8BFGQdF0cb5sbPtsnd16cwgPyl2SA7QMlOuZcOBR2DMw==
Return-Path: <python.list@tim.thechases.com>
X-Original-To: python-list@python.org
Delivered-To: python-list@mail.python.org
X-Spam-Status: OK 0.004
X-Spam-Evidence: '*H*': 0.99; '*S*': 0.00; 'test,': 0.05; 'subject:file': 0.07; 'forcing': 0.09; 'pyodbc': 0.09; 'python': 0.10; '-tkc': 0.16; 'bypassing': 0.16; 'dfs': 0.16; 'from:addr:python.list': 0.16; 'from:addr:tim.thechases.com': 0.16; 'from:name:tim chase': 0.16; 'received:io': 0.16; 'received:psf.io': 0.16; 'summarize': 0.16; 'wrote:': 0.16; 'thus': 0.24; 'header:In-Reply-To:1': 0.24; 'time:': 0.27; '32-bit': 0.29; 'comparison': 0.29; 'code': 0.30; 'seconds': 0.31; 'curious': 0.33; 'file': 0.34; 'quite': 0.35; 'but': 0.36; '(and': 0.36; 'to:addr:python-list': 0.36; 'subject:: ': 0.37; 'received:10': 0.37; 'charset:us-ascii': 0.37; 'to:addr:python.org': 0.40; 'received:23': 0.84; 'subject:write': 0.84; 'vba': 0.84
X-Sender-Id: wwwh|x-authuser|tim@thechases.com
X-Sender-Id: wwwh|x-authuser|tim@thechases.com
X-MC-Relay: Neutral
X-MailChannels-SenderId: wwwh|x-authuser|tim@thechases.com
X-MailChannels-Auth-Id: wwwh
X-MC-Loop-Signature: 1462289557638:468459481
X-MC-Ingress-Time: 1462289557638
In-Reply-To: <ng98um$hjh$1@dont-email.me>
X-Mailer: Claws Mail 3.11.1 (GTK+ 2.24.25; x86_64-pc-linux-gnu)
X-AuthUser: tim@thechases.com
X-BeenThere: python-list@python.org
X-Mailman-Version: 2.1.22
Precedence: list
List-Id: General discussion list for the Python programming language <python-list.python.org>
List-Unsubscribe: <https://mail.python.org/mailman/options/python-list>, <mailto:python-list-request@python.org?subject=unsubscribe>
List-Archive: <http://mail.python.org/pipermail/python-list/>
List-Post: <mailto:python-list@python.org>
List-Help: <mailto:python-list-request@python.org?subject=help>
List-Subscribe: <https://mail.python.org/mailman/listinfo/python-list>, <mailto:python-list-request@python.org?subject=subscribe>
X-Mailman-Original-Message-ID: <20160503102850.63cec18a@bigbox.christie.dr>
X-Mailman-Original-References: <ng6jie$1ap$1@dont-email.me> <85vb2xgj2i.fsf@benfinney.id.au> <mailman.298.1462164614.32212.python-list@python.org> <ng6mn7$8nv$1@dont-email.me> <1462166136.1167243.595273897.291B0865@webmail.messagingengine.com> <mailman.303.1462166138.32212.python-list@python.org> <ng6q67$gnm$1@dont-email.me> <1462170452.1180117.595306673.68B64F02@webmail.messagingengine.com> <mailman.308.1462170455.32212.python-list@python.org> <ng6vsl$1jc$1@dont-email.me> <572823D8.6050204@gmail.com> <mailman.335.1462248430.32212.python-list@python.org> <ng98um$hjh$1@dont-email.me>
Xref: csiph.com comp.lang.python:108084

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