Re: [pysqlite] Erratic behavior under high loads, with APSW code sample

On Mon, Jun 30, 2008 at 1:46 PM, Glenn Maynard <[email protected]> wrote:

> On Mon, Jun 30, 2008 at 01:30:41PM -0500, Frank McIngvale wrote:
> > This is vs. APSW, though. It doesn't have a .commit() and it defaults (my
> > understanding) to the pysqlite equivalent of 'isolation_level=None', so
> > SQLite is doing an auto-transaction for each INSERT (in my example). I
> > definitely am getting data written, just not the whole amount (under
> POSIX;
> > Windows is fine).
> >
> > I can post a pysqlite equivalent sample if that would help. I suspect the
> > problem lies in SQLite itself, but I wanted to see first if anyone here
> > could run & replicate the issue on a non-Windows box.
>
> I don't see any problems using the sqlite3 module in either transaction
> mode
> (3.4.2).  (I don't have APSW installed.)


OK, thanks. Which platform? (I think I'll repost the sample using pysqlite
just to make sure we're talking about the same code.)

frank


>
> --
> Glenn Maynard
> _______________________________________________
> list-pysqlite mailing list
> list-pysqlite-FR6EJeJVuqdwc357pe9rcyQmJico6nz3epZhswDD4dQ@public.gmane.org
> http://itsystementwicklung.de/cgi-bin/mailman/listinfo/list-pysqlite
>

_______________________________________________
list-pysqlite mailing list
list-pysqlite-FR6EJeJVuqdwc357pe9rcyQmJico6nz3epZhswDD4dQ@public.gmane.org
http://itsystementwicklung.de/cgi-bin/mailman/listinfo/list-pysqlite