I am sorry I won't able to share the complete program. Also it is quite some
work to extract that piece alone.
*Some good news. As a last resort I downloaded latest sqlite source,
compiled and ran the tests. It never failed. The problem seems **to be fixed
in 3.7.6.3.*
But I am still curious to
On 06/23/2011 12:11 PM, Anoop K wrote:
> I am using sqlite3(sqlite-3.7.0.1) with WAL enabled as storage for a
> multiprocessing daemon(python). On doing a BULK insert of .5 million rows
> each of size 230 bytes in batches of 500 where each batch is a transaction,
> following errors happen in other
On 23 Jun 2011, at 2:22pm, Anoop K wrote:
> By the way I
> did change it to 'NORMAL' and tried. The issues mentioned in the mail still
> happened
Okay, that's useful information.
Simon.
___
sqlite-users mailing list
sqlite-users@sqlite.org
I had to turn synchronous=OFF to achieve required performance. By the way I
did change it to 'NORMAL' and tried. The issues mentioned in the mail still
happened
Some more info regarding the problem. At this high load IO Wait was about
50-60%.
Thanks
Anoop
On Thu, Jun 23, 2011 at 5:42 PM, Simon
On 23 Jun 2011, at 6:11am, Anoop K wrote:
> Sqlite3 configuration
>
> - 'PRAGMA synchronous=OFF'
Remove that and try it again.
Simon.
___
sqlite-users mailing list
sqlite-users@sqlite.org
I am using sqlite3(sqlite-3.7.0.1) with WAL enabled as storage for a
multiprocessing daemon(python). On doing a BULK insert of .5 million rows
each of size 230 bytes in batches of 500 where each batch is a transaction,
following errors happen in other processes which perform (<10) SELECTS and
6 matches
Mail list logo