-bin/mailman/listinfo/sqlite-users
--
View this message in context:
http://www.nabble.com/Faster-inserts-in-SQlite-...-tp25530282p25661817.html
Sent from the SQLite mailing list archive at Nabble.com.
___
sqlite-users mailing list
sqlite-users
this message in context:
http://www.nabble.com/Faster-inserts-in-SQlite-...-tp25530282p25530282.html
Sent from the SQLite mailing list archive at Nabble.com.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman
Hello!
On Monday 21 September 2009 15:05:04 Atul_Vaidya wrote:
5. PRAGMA cache_size = 12000;
I use value 128 000 on servers.
You must set pragma page_size=4096;
If database is not empty is needed to vacuum it.
i also avoid the update calls, and i do all the insertion in between Begin
You must set pragma page_size=4096;
Can I ask why must and this number? Why not the maximum 32768?
Pavel
On Mon, Sep 21, 2009 at 11:45 AM, Alexey Pechnikov
pechni...@mobigroup.ru wrote:
Hello!
On Monday 21 September 2009 15:05:04 Atul_Vaidya wrote:
5. PRAGMA cache_size = 12000;
I use
Hello!
On Monday 21 September 2009 19:50:37 Pavel Ivanov wrote:
You must set pragma page_size=4096;
Can I ask why must and this number? Why not the maximum 32768?
$ sudo tune2fs -l /dev/sdb1|grep 4096
Block size: 4096
Most modern FS have the same block size.
Best regards,
Most modern FS have the same block size.
Though I don't think that in case of synchronous = OFF there's any
benefit of using pages of the exactly same size as block in file
system. Correct me if I'm wrong.
Pavel
On Mon, Sep 21, 2009 at 2:53 PM, Alexey Pechnikov
pechni...@mobigroup.ru wrote:
Hello!
On Monday 21 September 2009 23:11:57 Pavel Ivanov wrote:
Most modern FS have the same block size.
Though I don't think that in case of synchronous = OFF there's any
benefit of using pages of the exactly same size as block in file
system. Correct me if I'm wrong.
Have you any IO
Have you any IO operations? As result you have dependence of page
size.
Though your performance most probably will not depend on these
operations because they will be executed at some random times by OS.
And they will be collected to have multiple blocks in one operation
anyway...
I don't have
On Mon, Sep 21, 2009 at 03:37:02PM -0400, Pavel Ivanov wrote:
Have you any IO operations? As result you have dependence of page
size.
Though your performance most probably will not depend on these
operations because they will be executed at some random times by OS.
And they will be