On 2012-01-13 15:35, Richard Hipp wrote:
On Fri, Jan 13, 2012 at 3:34 PM, Normand Mongeau<nmong...@theobjects.com>wrote:
On 2012-01-13 15:23, Richard Hipp wrote:
On Fri, Jan 13, 2012 at 3:19 PM, Normand Mongeau<nmongeau@theobjects.**
com<nmong...@theobjects.com>>wrote:
not really, no. This is a server that receives files, and the transaction
below means a file has arrived.
Does your server have a really, really slow disk drive? Transaction
commit
normally takes milliseconds. I'm not sure why you are having problems.
Might another process be soaking up all the disk I/O bandwidth and making
your process have to wait for an available slot?
No, my machine is a normal PC, and I tried on several machines and they
all react the same way.
What version of SQLite are you using? Have you tried running with all
anti-virus software disabled, to see if that makes a difference?
3.7.9 is the version I'm using (statically linked BTW). Running on
another machine with no anti-virus gives me similar times.
Normand
Normand
On 2012-01-13 15:16, Simon Slavin wrote:
On 13 Jan 2012, at 7:57pm, Normand Mongeau wrote:
begin immediate transaction
insert 1 record in tableA
insert 1 record in tableB
insert 1 record in tableC
commit transaction
Inserting 534 records takes about 75 seconds. Most of the time (about
71
seconds) is spent on the commit transaction instruction.
Can you put one transaction around the whole lot rather than 178
separate
transactions ?
Simon.
______________________________****_________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-****bin/mailman/listinfo/sqlite-****users<http://sqlite.org:8080/cgi-**bin/mailman/listinfo/sqlite-**users>
<http://sqlite.org:8080/**cgi-bin/mailman/listinfo/**sqlite-users<http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users>
______________________________****_________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-****bin/mailman/listinfo/sqlite-****users<http://sqlite.org:8080/cgi-**bin/mailman/listinfo/sqlite-**users>
<http://sqlite.org:8080/**cgi-bin/mailman/listinfo/**sqlite-users<http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users>
______________________________**_________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-**bin/mailman/listinfo/sqlite-**users<http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users>
--
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
