geopackage performance

[Uffe Kousgaard]

While doing another converter application for Ordnance Survey databases,
I noticed some major performance differencies.

I have a 1 GB geopackage. Main table has 650000 records and 159 fields.

I use mapbasic to run these 2 simple sql's:

select highway,count(*)
from mrn_ntwk_transportlink
group by highway
(16 groups....)

select max(len(name))
from mrn_ntwk_transportlink

Requires a total of 90 secs. MapInfo 2023.1

Then I run the same SQL using free SQLiteStudio (https://sqlitestudio.pl).
It takes 1½ sec.
I get the same 1½ sec using UniDAC library from Devart.
Or if I run it on a TAB copy of the geopackage.

Quite a lot of room for geopackage improvement, I think.

Regards
Uffe Kousgaaard