How to use SQLite (sqlite3) more efficiently

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> (permalink)
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

Show key headers only | View raw

 > 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

Back to comp.lang.python | Previous | Next | Find similar | Unroll thread

Thread

How to use SQLite (sqlite3) more efficiently R Johnson <ps16thypresenceisfullnessofjoy@gmail.com> - 2014-06-06 14:15 -0400

csiph-web