Python 2.6 and Sqlite3 - Slow

[ian douglas]

>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, <bruceg113355 at 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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.python.org/pipermail/python-list/attachments/20120827/f9ba6724/attachment.html>