>From the sqlite documentation he quoted, it appears that ANY network filesystem, local or otherwise, should be avoided. On Aug 27, 2012 8:13 PM, <bruceg113...@gmail.com> wrote:
> 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 > -- > http://mail.python.org/mailman/listinfo/python-list >
-- http://mail.python.org/mailman/listinfo/python-list
