Thanks Jukka! Also, thanks for providing the test dataset - that made it
much easier to implement and test the geopackage parsing.
-lreeder
On Thu, Feb 6, 2014 at 8:15 AM, Rahkonen Jukka (Tike) <
jukka.rahko...@mmmtike.fi> wrote:
> Hi Larry,
>
>
>
> DB Query reads data from GPKG fast!
>
> Read 300000 points: 1 second
>
> Read 530000 linestrings: 5 seconds
>
> Read 550000 polygons: 8 seconds
>
>
>
> All geometrytypes seem to work perfectly. Congratulations!
>
>
>
> -Jukka-
>
>
>
> Larry Reeder wrote:
>
>
>
> All,
>
> I've posted new versions of the JUMP Database Query Plugin on SourceForge
> at https://sourceforge.net/projects/jumpdbqplugin/files/jumpdbqplugin/.
> The main features in this release are basic Geopackage support, as well as
> inclusion of some JDBC drivers so that users don't have to download them
> separately.
>
>
> Details:
>
> - Followed Jukka Rahkonen's suggestion and implemented Geopackage
> encoding supported by the SQLite/Spatialite plugin. This isn't full
> Geopackage support, but the plugin recognizes the Geopackage geometries and
> can create features from them.
> - MySQL and Spatialite JDBC drivers are included in the binary, so
> users don't have to download those separately. Users will still have to
> download Oracle JDBC due to its terms of service. Also, since I didn't
> want to track the various Spatialite DLL releases across multiple
> platforms, people desiring to use Spatialite functions though the plugin
> will need to install Spatialite or the Spatialite DLLs separately. Of
> course, users can still select features from a Spatialite database without
> installing Spatialite.
> - Implemented suggestion by Wei GuoBing to use DB metadata to better
> determine if an Oracle STRUCT type was really a geometry.
>
>
>
> -Larry
>
>
>
>
>
>
> ------------------------------------------------------------------------------
> Managing the Performance of Cloud-Based Applications
> Take advantage of what the Cloud has to offer - Avoid Common Pitfalls.
> Read the Whitepaper.
>
> http://pubads.g.doubleclick.net/gampad/clk?id=121051231&iu=/4140/ostg.clktrk
> _______________________________________________
> Jump-pilot-devel mailing list
> Jump-pilot-devel@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel
>
>
------------------------------------------------------------------------------
Managing the Performance of Cloud-Based Applications
Take advantage of what the Cloud has to offer - Avoid Common Pitfalls.
Read the Whitepaper.
http://pubads.g.doubleclick.net/gampad/clk?id=121051231&iu=/4140/ostg.clktrk
_______________________________________________
Jump-pilot-devel mailing list
Jump-pilot-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/jump-pilot-devel
