Oyvind Idland wrote:
> Thanks for responses :)
>
> Whereby "objects" you mean "rows," no? You are getting upward of 5500
>> sustained inserts per second. That sounds pretty good. That said, are
>> you using transactions? See what difference that makes.
>>
>
> Yep, I meant rows. Inserting rows in
Thanks for responses :)
Whereby "objects" you mean "rows," no? You are getting upward of 5500
> sustained inserts per second. That sounds pretty good. That said, are
> you using transactions? See what difference that makes.
>
Yep, I meant rows. Inserting rows in the data table is much faster
try looking at the pragmas page and determine what you can get away with.
For me, I relaxed the synchronization requirements and also the locking
strictness, and I was able to boost my speeds to 80,000 records per second
:) FYI, my records only consist of 6 numbers and a binary.
On Wed, Dec 3,
Oyvind Idland wrote:
> Hi,
>
> I am fiddling around with the r-tree module a bit, which works great and
> gives the effect I am looking for.
>
> The only thing is that I wish I could speed up inserts. Populating the
> rtree-index with 1 million objects
> takes about 180 seconds (using prepared
Oyvind Idland wrote:
>
>
> Is there any trick to speed up the inserts here ?
>
Are you doing the inserts inside a transaction?
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
On 12/3/08, Oyvind Idland <[EMAIL PROTECTED]> wrote:
> Hi,
>
> I am fiddling around with the r-tree module a bit, which works great and
> gives the effect I am looking for.
>
> The only thing is that I wish I could speed up inserts. Populating the
> rtree-index with 1 million objects
> takes
Hi,
I am fiddling around with the r-tree module a bit, which works great and
gives the effect I am looking for.
The only thing is that I wish I could speed up inserts. Populating the
rtree-index with 1 million objects
takes about 180 seconds (using prepared statements).
Is there any trick to
7 matches
Mail list logo
