{"action":"opened","issue":{"url":"https://api.github.com/repos/ngageoint/geopackage-js/issues/107","repository_url":"https://api.github.com/repos/ngageoint/geopackage-js","labels_url":"https://api.github.com/repos/ngageoint/geopackage-js/issues/107/labels{/name}","comments_url":"https://api.github.com/repos/ngageoint/geopackage-js/issues/107/comments","events_url":"https://api.github.com/repos/ngageoint/geopackage-js/issues/107/events","html_url":"https://github.com/ngageoint/geopackage-js/issues/107","id":304886790,"number":107,"title":"Slow point loading from gpkg in Leaflet","user":{"login":"kristiansvenssonwsp","id":10772529,"avatar_url":"https://avatars3.githubusercontent.com/u/10772529?v=4","gravatar_id":"","url":"https://api.github.com/users/kristiansvenssonwsp","html_url":"https://github.com/kristiansvenssonwsp","followers_url":"https://api.github.com/users/kristiansvenssonwsp/followers","following_url":"https://api.github.com/users/kristiansvenssonwsp/following{/other_user}","gists_url":"https://api.github.com/users/kristiansvenssonwsp/gists{/gist_id}","starred_url":"https://api.github.com/users/kristiansvenssonwsp/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/kristiansvenssonwsp/subscriptions","organizations_url":"https://api.github.com/users/kristiansvenssonwsp/orgs","repos_url":"https://api.github.com/users/kristiansvenssonwsp/repos","events_url":"https://api.github.com/users/kristiansvenssonwsp/events{/privacy}","received_events_url":"https://api.github.com/users/kristiansvenssonwsp/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2018-03-13T18:36:10Z","updated_at":"2018-03-13T18:36:10Z","closed_at":null,"author_association":"NONE","body":"Hi!\r\n\r\nThanks for making this library, I really like the idea of working with geopackage in Leaflet! I tried loading a point set with about 72k points and have run into load performance issues. It takes several minutes to display all the points. And it seems that points are loaded in random order and not within the current bound. I guess Im doing something wrong.\r\n\r\nFor example in Qgis the geopackage file loads and displays instantly. Any ideas on how to load the point features quicker? \r\n\r\nI attached a working example (zip) file here for anyone to look at and debug. The geopackage are generated with a spatial index. The gpkg file in the example is generaed from Qgis 3 but I also tried with the same dataset using gdal but with the same results.\r\n\r\nThanks!\r\n[geop.zip](https://github.com/ngageoint/geopackage-js/files/1808185/geop.zip)\r\n"}}
{"actor":{"display_login":"kristiansvenssonwsp"}}