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

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.)

-- 
Glenn Maynard