Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.lang.python > #28025

Re: Python 2.6 and Sqlite3 - Slow

References <d6e9f696-da86-4aa3-8930-69cf33dd2837@googlegroups.com> <mailman.3896.1346142467.4697.python-list@python.org> <36e5f80f-ff34-4f2f-a7e2-1488549f6e9b@googlegroups.com> <9ecq38h3151mcgo92d99r4goagmrm84rm4@invalid.netcom.com>
Date 2012-08-29 00:01 +0200
Subject Re: Python 2.6 and Sqlite3 - Slow
From Pedro Larroy <pedro.larroy.lists@gmail.com>
Newsgroups comp.lang.python
Message-ID <mailman.3905.1346191296.4697.python-list@python.org> (permalink)

Show all headers | View raw

Try incrementing the variable cursor.arraysize a lot.

Pedro.

On Tue, Aug 28, 2012 at 11:20 PM, Dennis Lee Bieber
<wlfraed@ix.netcom.com> wrote:
> On Tue, 28 Aug 2012 10:25:35 -0700 (PDT), bruceg113355@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@ix.netcom.com    HTTP://wlfraed.home.netcom.com/
>
> --
> http://mail.python.org/mailman/listinfo/python-list

Back to comp.lang.python | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

Thread

Python 2.6 and Sqlite3 - Slow bruceg113355@gmail.com - 2012-08-26 18:23 -0700
  Re: Python 2.6 and Sqlite3 - Slow Ulrich Eckhardt <ulrich.eckhardt@dominolaser.com> - 2012-08-27 17:50 +0200
    Re: Python 2.6 and Sqlite3 - Slow ahsanraza211@gmail.com - 2012-08-27 09:53 -0700
    Re: Python 2.6 and Sqlite3 - Slow bruceg113355@gmail.com - 2012-08-27 13:41 -0700
      Re: Python 2.6 and Sqlite3 - Slow Cameron Simpson <cs@zip.com.au> - 2012-08-28 18:27 +1000
        Re: Python 2.6 and Sqlite3 - Slow bruceg113355@gmail.com - 2012-08-28 10:25 -0700
          Re: Python 2.6 and Sqlite3 - Slow Dennis Lee Bieber <wlfraed@ix.netcom.com> - 2012-08-28 17:20 -0400
          Re: Python 2.6 and Sqlite3 - Slow Pedro Larroy <pedro.larroy.lists@gmail.com> - 2012-08-29 00:01 +0200
        Re: Python 2.6 and Sqlite3 - Slow bruceg113355@gmail.com - 2012-08-28 10:25 -0700
  Re: Python 2.6 and Sqlite3 - Slow Demian Brecht <demianbrecht@gmail.com> - 2012-08-27 13:54 -0700
    Re: Python 2.6 and Sqlite3 - Slow bruceg113355@gmail.com - 2012-08-27 17:55 -0700
      Re: Python 2.6 and Sqlite3 - Slow Bryan <bryanjugglercryptographer@yahoo.com> - 2012-08-27 19:32 -0700
        Re: Python 2.6 and Sqlite3 - Slow bruceg113355@gmail.com - 2012-08-27 20:09 -0700
          Re: Python 2.6 and Sqlite3 - Slow Bryan <bryanjugglercryptographer@yahoo.com> - 2012-08-27 22:26 -0700
          Re: Python 2.6 and Sqlite3 - Slow Dennis Lee Bieber <wlfraed@ix.netcom.com> - 2012-08-28 01:33 -0400

csiph-web