Hi Nicolas,
My application is windows based. I did set the pragma Page
Size = 4096 as suggested by Alexey. but, it hardy made any difference to
the speed. I am abandoning the multi-threading idea, as the other components
used in my application aren't thread safe.
Also, i was wondering, if apart from Begin Transaction/End Transaction, is
there any other method for batched inserts in SQlite ?
Can i use triggers for this ?
If one has to use ZFS in tandem with Windows OS,(mine is Vista/Xp),how is
this achieved ?
Thanks for awesome support,
Regards,
Atul.
Nicolas Williams wrote:
>
> 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 collected to have multiple blocks in one operation
>> anyway...
>> I don't have good knowledge of how disk cache works in kernel to say
>> if it will be beneficiary to send data there in chunks equal to blocks
>> on disk as opposed to chunks of any arbitrary size...
>
> It is well-known that matching DB page size and filesystem record size
> is important for improving performance.
>
> SQLite3 supports power-of-2 page sizes from 512 to 32KB.
>
> Most filesystems use 512, 4096 or 8192 byte blocks. SQLite3's default
> pagesize is 1024 bytes.
>
> In the case of ZFS the fs recordsize is variable up to 128KB, and can be
> tuned per-dataset. You should set the recordsize to 32KB for ZFS
> datasets containing SQLite3 DBs, and you should set the SQLite3 pagesize
> to 32KB.
>
> Nico
> --
> _______________________________________________
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-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@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
