Python 2.6 and Sqlite3 - Slow

[bruceg113355 at gmail.com]

On Monday, August 27, 2012 10:32:47 PM UTC-4, Bryan wrote:
> bruceg113 wrote:
> 
> > I selected sqlite for the following reasons:
> 
> >
> 
> > 1) Ships with Python.
> 
> > 2) Familiar with Python.
> 
> > 3) The Sqlite description athttp://www.sqlite.org/whentouse.htmlappears to meet my requirements:
> 
> >     Very low volume and concurrency, small datasets, simple to use.
> 
> 
> 
> All good reasons, but a database file on a network drive is
> 
> contraindication for SQLite. A Google site-specific search
> 
> for "network" on www.sqlite.org, finds such warnings as:
> 
> 
> 
> "We have received reports of implementations of both Windows network
> 
> filesystems and NFS in which locking was subtly broken. We can not
> 
> verify these reports, but as locking is difficult to get right on a
> 
> network filesystem we have no reason to doubt them. You are advised to
> 
> avoid using SQLite on a network filesystem in the first place, since
> 
> performance will be slow."
> 
> 
> 
> That said, I don't know where your 17 seconds is going.
> 
> 
> 
> -Bryan

Bryan,

Thank you for your reply. 
Are you saying having a sqlite database file on a shared LOCAL network drive is problematic? 

Bruce