Hello dear (System.Data.)SQLite users,
I am using System.Data.SQLite in combination with Spatialite which works
very well.
One problem I currently have is that when I'm trying to insert several
milions of records (namely road segments with just two columns: Id
INTEGER, Geometry LINESTRING) it takes a very long time (about an hour
or more).
The index on the Geometry column is created after all records are
inserted and the whole insertion process is encapsulated in one big
transaction.
I was then trying to reuse the same insertion-command (SQLiteCommand)
with two parameters for the Id and the Geometry (doing this for
non-spatial tables resulted in a significant performance boost).
Now, the problem is that I don't have a fitting DbType for LINESTRING
(or other GEOMETRY types).
Using a parameter without specifying the DbType then yields an exception.
I also tryed using DbType.String which also caused an exception.
So my question is:
Is there any possibility to use commands with command parameters to
insert spatial data with System.Data.SQLite?
PS:
This is my first time writing to a mailing list so I hope the form is right.
Best regards
Markus
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
