Re: [gdal-dev] GeoPackage Open() Performance

2018-03-22 Thread Kevin Bentley
Ok, yes, thank you, the code in the trunk made a huge difference. I appreciated it! On Thu, Mar 22, 2018 at 3:21 AM, Even Rouault wrote: > Kevin, > > > I've been working on some large GeoPackage files that have a lot of > layers. > > One in particular has over 5000 layers. It was taking a good 5

Re: [gdal-dev] GeoPackage Open() Performance

2018-03-22 Thread Even Rouault
Kevin, > I've been working on some large GeoPackage files that have a lot of layers. > One in particular has over 5000 layers. It was taking a good 5+ minutes > just to open, so I did some analysis. Here's what I found: > > By far the biggest hit is in a query to sqlite_master (called > from OGRG

[gdal-dev] GeoPackage Open() Performance

2018-03-20 Thread Kevin Bentley
I've been working on some large GeoPackage files that have a lot of layers. One in particular has over 5000 layers. It was taking a good 5+ minutes just to open, so I did some analysis. Here's what I found: By far the biggest hit is in a query to sqlite_master (called from OGRGeoPackageTableLayer: