Path: csiph.com!fu-berlin.de!uni-berlin.de!not-for-mail
From: Chris Angelico <rosuav@gmail.com>
Newsgroups: comp.lang.python
Subject: Re: asyncio and blocking - an update
Date: Fri, 12 Feb 2016 19:19:41 +1100
Lines: 11
Message-ID: <mailman.72.1455265184.22075.python-list@python.org>
References: <n9c4p3$gmp$1@ger.gmane.org> <n9h75i$ag1$1@ger.gmane.org> <CAPTjJmrVCkKAEevc9TW8FYYTnZgRUMPHectz+bD=DQRphXYTpw@mail.gmail.com> <n9ha5v$pb9$1@ger.gmane.org> <CAPTjJmor8dMv2TDtq8RHQgWeSAaZgAmxK9gFth=OojhidWHs3w@mail.gmail.com> <n9hjfp$ad7$1@ger.gmane.org> <n9k4f5$p8s$1@ger.gmane.org>
Mime-Version: 1.0
Content-Type: text/plain; charset=UTF-8
X-Trace: news.uni-berlin.de Zbv7+5RjxE7K2O6rSenWhAU5KV5MLyz12f0GRsVkyCuQ==
Return-Path: <rosuav@gmail.com>
X-Original-To: python-list@python.org
Delivered-To: python-list@mail.python.org
X-Spam-Status: OK 0.052
X-Spam-Evidence: '*H*': 0.90; '*S*': 0.00; 'cc:addr:python-list': 0.09; '2016': 0.16; 'cool.': 0.16; 'from:addr:rosuav': 0.16; 'from:name:chris angelico': 0.16; 'received:io': 0.16; 'received:psf.io': 0.16; 'wrote:': 0.16; 'obviously': 0.16; 'cc:2**0': 0.20; 'cc:addr:python.org': 0.20; 'feb': 0.23; 'header :In-Reply-To:1': 0.24; 'fri,': 0.27; 'message-id:@mail.gmail.com': 0.27; 'looks': 0.29; 'second,': 0.29; 'subject:update': 0.29; 'task': 0.30; 'seconds': 0.31; 'useful': 0.33; 'received:google.com': 0.35; 'but': 0.36; 'received:209.85': 0.36; 'pm,': 0.36; 'subject:: ': 0.37; '12,': 0.37; 'received:209.85.213': 0.37; 'received:209': 0.38; 'maximum': 0.61; 'frank': 0.72; 'saw': 0.77; 'chrisa': 0.84; 'to:none': 0.91; 'good,': 0.93
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:in-reply-to:references:date:message-id:subject:from:cc :content-type; bh=F4PvT6Bo77rQZ7LpusxWWEMWLTamMWDxKKfyl3/l/aM=; b=te++U1SP5Zf6Fp0pRYj3LHo/FSPbhBeJLMSKhwIprg337ysKsqlETAEVrFqThhGFJW 5jtoA4kwXF+et3vRZjrYX38X/omUmLc3/ZKmLjOEuFu3Op6j9Ip3tO896l1RCI1/cNVj GK/HEY3reC1+whQLnBMgLpuDnIGlmzOsZK+TCsmDbFoOwXRGBwUIZcLT7Qagb40zR7BZ YVdyEVt/fIIudQxoixwgR9V1APt4BH4tkwmk/9AMdSl/cN+JqZZUDrjzWwev5KHzyZsY V/VFZQw3wlcKShxpUt7H2+7knxA70wjmxncN6+zVmFUopo33W56Jd4hjJfkGrp+MQ7DV JIig==
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20130820; h=x-gm-message-state:mime-version:in-reply-to:references:date :message-id:subject:from:cc:content-type; bh=F4PvT6Bo77rQZ7LpusxWWEMWLTamMWDxKKfyl3/l/aM=; b=R2wbyvZPQjr3MCV8PgSEMmvvHPRlfZDU859aVB+ExUiMxKHEKLUs0ikr8vNsn1PGes GkKRjqBWjft6BxtiIbxrQveWCl6Aw/dj1VBV9ajS3oqvG+6Ai4TsN05/T9HufTbevzJw rjyayhhh/NIh2tsMbB7NpF45IF4w8M7l6Y9FJLghY4QUBkJo5lNBSgnSIifi8ZxSovlv EQlaQ+c9FFWY4wZYERkwFVvtRTZmfWD7VY9jcCP/kfFNx3i+/POzfa3ardmxgg0px6uI fGJ1L0kIhxMMO2cTbN2QBYhOiH6EVAWGhV1uKJvnMJvnF7lnw5gdukcOxccPizg0nISd SkPQ==
X-Gm-Message-State: AG10YORHUtMqREqZEUFopiBrdgLcSavAMzsTEjfQqjm7geFlQcGFzQlum/qsTvlyOj2JPlmNVZ1CStt6x8Ys/w==
X-Received: by 10.50.28.105 with SMTP id a9mr2787750igh.94.1455265182167; Fri, 12 Feb 2016 00:19:42 -0800 (PST)
In-Reply-To: <n9k4f5$p8s$1@ger.gmane.org>
X-BeenThere: python-list@python.org
X-Mailman-Version: 2.1.21rc2
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>
Xref: csiph.com comp.lang.python:102854

On Fri, Feb 12, 2016 at 7:17 PM, Frank Millman <frank@chagford.com> wrote:
> Using run_in_executor() and cur.fetchall(), I experience delays of up to 2
> seconds while the task is active.
>
> Using my approach, the maximum I saw was about a tenth of a second, and that
> is because I was looking for it - a normal user would not notice. Obviously
> the task took longer, but I can live with that trade-off.

That looks like good, useful data! Cool.

ChrisA