Python 2.6 and Sqlite3 - Slow

[Pedro Larroy]

Try incrementing the variable cursor.arraysize a lot.

Pedro.

On Tue, Aug 28, 2012 at 11:20 PM, Dennis Lee Bieber
<wlfraed at ix.netcom.com> wrote:
> On Tue, 28 Aug 2012 10:25:35 -0700 (PDT), bruceg113355 at gmail.com
> declaimed the following in gmane.comp.python.general:
>
>>
>> Doesn't the last paragraph imply that SQLite can operate on a network drive.
>>
>
>         Most anything "can operate" on a network drive... But should it?
>
>         The main thing the documentation is explaining is that one
> application accessing the database FILE does NOT LOCK OTHERS from
> accessing the file. Nothing about how the file is accessed. A
> low-activity web service would allow lots of people to concurrently
> access it -- but the processes that are doing said access are all local
> to the database file.
>
>         Technically, M$ Access/JET (which is also file server database) also
> permits multiple clients -- but the locking becomes a pain.
> --
>         Wulfraed                 Dennis Lee Bieber         AF6VN
>         wlfraed at ix.netcom.com    HTTP://wlfraed.home.netcom.com/
>
> --
> http://mail.python.org/mailman/listinfo/python-list