On Mon, Mar 21, 2016 at 1:53 PM, Christoph Hormann <[email protected]>
wrote:

>
> The general problem with SQLite based files is that they are always read
> and written through the SQLite database engine which is not
> particularly good for sequential write and read operations.

In my experience the engine defaults to one write operation per transaction
which is very slow.  If you are processing a large amount of data you need
to explicitly open and then later (after many writes) commit the
transaction if you want reasonable performance.
_______________________________________________
talk mailing list
[email protected]
https://lists.openstreetmap.org/listinfo/talk

Reply via email to