Python 2.6 and Sqlite3 - Slow
bryanjugglercryptographer at yahoo.com
Tue Aug 28 04:32:47 CEST 2012
> 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.
More information about the Python-list