Path: csiph.com!newsfeed.hal-mli.net!feeder3.hal-mli.net!news.stack.nl!newsfeed.xs4all.nl!newsfeed1a.news.xs4all.nl!xs4all!post.news.xs4all.nl!not-for-mail
Return-Path: <ps16thypresenceisfullnessofjoy@gmail.com>
X-Original-To: python-list@python.org
Delivered-To: python-list@mail.python.org
X-Spam-Status: OK 0.072
X-Spam-Evidence: '*H*': 0.86; '*S*': 0.00; 'referring': 0.07; 'default.': 0.09; 'pep': 0.09; 'subject:How': 0.10; 'python': 0.11; "wouldn't": 0.14; 'none).': 0.16; 'subject:sqlite3': 0.16; 'through,': 0.16; 'wxpython': 0.16; 'this?': 0.23; 'header:User- Agent:1': 0.23; '(by': 0.24; 'headers': 0.24; 'specifies': 0.24; "i've": 0.25; 'posts': 0.26; 'point': 0.28; 'correct': 0.29; 'subject:) ': 0.29; 'mode': 0.30; '(which': 0.31; "skip:' 10": 0.31; 'header,': 0.31; 'post.': 0.31; 'says': 0.33; 'guess': 0.33; 'sense': 0.34; 'could': 0.34; 'subject: (': 0.35; 'but': 0.35; 'received:google.com': 0.35; 'google': 0.35; 'there': 0.35; 'executing': 0.36; "didn't": 0.36; 'list': 0.37; 'performance': 0.37; 'message-id:@gmail.com': 0.38; 'thank': 0.38; 'to:addr :python-list': 0.38; 'explain': 0.39; 'to:addr:python.org': 0.39; 'mailing': 0.39; 'how': 0.40; 'read': 0.60; 'manually': 0.60; "you're": 0.61; 'you.': 0.62; 'subject:more': 0.64; 'more': 0.64; 'details': 0.65; 'reply': 0.66; 'subject': 0.69; 'to,': 0.72; 'timothy': 0.84; 'decreased': 0.91; 'transactions': 0.91
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=message-id:date:from:user-agent:mime-version:to:subject :content-type:content-transfer-encoding; bh=uAIlqVDhMuGY/ksz8LdILQ0acNiJD9/aimQCJTvMRg8=; b=cZgV7IZiHJSs6DiKm2mv/pMm6UvaTrK3D/4dldYNUzQj12MQE+sgWTGtMNTL/Vjtpo Fy75QMtEI/kr0OotrQZFmggPIyRaljGc3+ItzO9Tz5h3hxe7X97YFyZj8sOKPJrsYEtL Ic4srC9vjPrtxPDohQitVIkuv0ps5F6HtkRH9ScyXyEk6ti4QBxlTkZ7BmEih9RugU4E gfiaOeDqQv9rgn53X98iKMHZRJcXVZw5yd02xQ34qgmWTLGQELZW56aSU1t8J1YZQ8E6 TuXCfoZLQErKog54uCsM0TvXRiRPEhfKYzZ+Jw9vlmZh8CN7a5SYws6NsxtxTNZtQssL mYhg==
X-Received: by 10.229.70.196 with SMTP id e4mr11494623qcj.16.1402078530953; Fri, 06 Jun 2014 11:15:30 -0700 (PDT)
Date: Fri, 06 Jun 2014 14:15:25 -0400
From: R Johnson <ps16thypresenceisfullnessofjoy@gmail.com>
User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:24.0) Gecko/20100101 Thunderbird/24.5.0
MIME-Version: 1.0
To: python-list@python.org
Subject: How to use SQLite (sqlite3) more efficiently
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Antivirus: avast! (VPS 140606-1, 06/06/2014), Outbound message
X-Antivirus-Status: Clean
X-BeenThere: python-list@python.org
X-Mailman-Version: 2.1.15
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>
Newsgroups: comp.lang.python
Message-ID: <mailman.10828.1402078533.18130.python-list@python.org>
Lines: 24
NNTP-Posting-Host: 2001:888:2000:d::a6
X-Trace: 1402078533 news.xs4all.nl 2974 [2001:888:2000:d::a6]:47992
X-Complaints-To: abuse@xs4all.nl
Xref: csiph.com comp.lang.python:72877

 > The subject line isn't as important as a header, carried invisibly
 > through, that says that you were replying to an existing post. :)

Sorry for my ignorance, but I've never edited email headers before and 
didn't find any relevant help on Google. Could you please give some more 
details about how to do what you're referring to, or perhaps point me to 
a link that would explain more about it? (FYI, I read the Python mailing 
list on Google Groups, and reply to posts in Thunderbird, sending them 
to the Python-list email address.)

I was thinking that since I've been manually calling conn.commit() in my 
wxPython program after executing each SQL transaction, it would make 
sense to use autocommit mode (by setting 'isolation_level' to None). Am 
I correct about this? I've read on StackOverflow that there can be 
disadvantages to using autocommit mode for SQL databases in general, but 
they weren't elaborated. The only one I could think of would be 
decreased performance if SQL transactions are committed automatically 
more than necessary (which wouldn't apply in my case). I guess that's 
also likely why PEP 249 specifies that Python database implementations 
must have autocommit mode turned off by default.

Thank you.

-- Timothy