Path: csiph.com!usenet.pasdenom.info!gegeweb.org!de-l.enfer-du-nord.net!feeder1.enfer-du-nord.net!feeds.phibee-telecom.net!newsfeed.xs4all.nl!newsfeed5.news.xs4all.nl!xs4all!post.news.xs4all.nl!not-for-mail Return-Path: 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; 'subject:Python': 0.05; 'received:80.91': 0.09; 'received:80.91.229': 0.09; 'received:gmane.org': 0.09; 'received:list': 0.09; 'result;': 0.09; 'sqlite': 0.09; 'aug': 0.13; 'library': 0.15; '"file': 0.16; "(it's": 0.16; 'caching': 0.16; 'received:80.91.229.3': 0.16; 'received:plane.gmane.org': 0.16; 'sqlite3': 0.16; 'mon,': 0.16; 'handles': 0.18; 'saying': 0.18; 'shell': 0.18; 'file.': 0.20; 'affected': 0.22; 'runs': 0.22; "i'd": 0.22; 'tables': 0.23; 'command': 0.24; 'machine': 0.24; 'header:X-Complaints-To:1': 0.28; 'record': 0.28; 'maybe': 0.29; 'query': 0.30; 'code': 0.31; '(and': 0.32; 'gets': 0.32; 'file': 0.32; 'getting': 0.33; 'goes': 0.33; 'url:home': 0.33; 'handle': 0.33; 'to:addr:python-list': 0.33; 'dir': 0.35; 'open': 0.35; 'remote': 0.35; 'received:org': 0.36; 'smaller': 0.36; 'client': 0.36; 'charset:us-ascii': 0.36; 'level': 0.37; 'maintaining': 0.37; 'subject:: ': 0.38; 'instead': 0.39; 'to:addr:python.org': 0.39; 'header:Received:5': 0.40; 'your': 0.60; 'side': 0.61; 'traffic': 0.61; 'back': 0.62; 'email addr:gmail.com': 0.63; 'records': 0.68; 'dennis': 0.91; 'received:108': 0.91; 'processes,': 0.93 X-Injected-Via-Gmane: http://gmane.org/ To: python-list@python.org From: Dennis Lee Bieber Subject: Re: Python 2.6 and Sqlite3 - Slow Date: Tue, 28 Aug 2012 01:33:41 -0400 Organization: > Bestiaria Support Staff < References: <7c61db72-0b4a-4105-949d-89f2cc303e78@googlegroups.com> <6807651c-7b42-413e-939f-ec4e11137990@googlegroups.com> <306b0189-df90-478e-b7d4-420620121ab1@googlegroups.com> <852f8da0-d445-4d35-a144-139ed5d66e0e@ou2g2000pbc.googlegroups.com> <741a0854-8ea4-460f-a65f-1b0da1183437@googlegroups.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Gmane-NNTP-Posting-Host: adsl-108-73-117-120.dsl.klmzmi.sbcglobal.net X-Newsreader: Forte Agent 3.3/32.846 X-No-Archive: YES X-BeenThere: python-list@python.org X-Mailman-Version: 2.1.12 Precedence: list List-Id: General discussion list for the Python programming language List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Newsgroups: comp.lang.python Message-ID: Lines: 27 NNTP-Posting-Host: 2001:888:2000:d::a6 X-Trace: 1346132034 news.xs4all.nl 6973 [2001:888:2000:d::a6]:47759 X-Complaints-To: abuse@xs4all.nl Xref: csiph.com comp.lang.python:28012 On Mon, 27 Aug 2012 20:09:27 -0700 (PDT), bruceg113355@gmail.com declaimed the following in gmane.comp.python.general: > Are you saying having a sqlite database file on a shared LOCAL network drive is problematic? > I'd avoid it... SQLite3 (and M$ Access/JET) are "file server" databases. The client program runs the code of the engine as part of its processes, maintaining open file handles on the database file. That means an awful lot of network traffic to handle a query (it's not a case of a client getting just a few records back from the database in response to a select/where query... instead every record in the affected tables get transmitted across the network so the client side library can determine if it qualifies -- and then maybe writing the result set /back/ to the file in a temporary region before sending them back to the client as the result; on a true client/server only the query goes across, the database engine runs on the machine with the files, and only the smaller result set gets returned). At my level of knowledge, your DIR command shell might be sending "keep-alive" packets across the network and those of interfering with caching on the remote end. -- Wulfraed Dennis Lee Bieber AF6VN wlfraed@ix.netcom.com HTTP://wlfraed.home.netcom.com/