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
