benchmark: why Japan is so slow to render

[rinigus]

benchmark: why Japan is so slow to render

[rinigus]

database size 2.1GB

*** Page counts for all tables with their indices *****************************

OSM_ROADS......................................... 130453      20.2% 
OSM_BUILDINGS..................................... 87996       13.6% 
OSM_ROADS_GEN2.................................... 72386       11.2% 
IDX_OSM_ROADS_GEOMETRY_NODE....................... 71381       11.0% 
IDX_OSM_BUILDINGS_GEOMETRY_NODE................... 59300        9.2% 
IDX_OSM_ROADS_GEN2_GEOMETRY_NODE.................. 59115        9.1% 
OSM_LANDUSAGES.................................... 30095        4.7% 
IDX_OSM_ROADS_GEOMETRY_ROWID...................... 21940        3.4% 
IDX_OSM_ROADS_GEN2_GEOMETRY_ROWID................. 18037        2.8% 
IDX_OSM_BUILDINGS_GEOMETRY_ROWID.................. 17466        2.7% 
OSM_WATERWAYS..................................... 16428        2.5% 
IDX_OSM_LANDUSAGES_GEOMETRY_NODE.................. 6703         1.0% 
OSM_ROADS_GEN1.................................... 6043         0.93% 
IDX_OSM_ROADS_GEN1_GEOMETRY_NODE.................. 4591         0.71% 
IDX_OSM_WATERWAYS_GEOMETRY_NODE................... 3526         0.54% 
OSM_BRIDGES....................................... 2966         0.46% 
OSM_AMENITY_Z17................................... 2787         0.43% 
IDX_OSM_BRIDGES_GEOMETRY_NODE..................... 2593         0.40% 
IDX_OSM_AMENITY_Z17_GEOMETRY_NODE................. 2115         0.33% 
OSM_LANDUSAGES_GEN1............................... 2040         0.32% 
IDX_OSM_LANDUSAGES_GEOMETRY_ROWID................. 1779         0.27% 
OSM_WATERAREAS.................................... 1587         0.25% 
OSM_AREA_LABELS................................... 1537         0.24% 
IDX_OSM_WATERWAYS_LOW_GEOMETRY_NODE............... 1522         0.24% 
IDX_OSM_MOTORWAYS_GEN0_GEOMETRY_NODE.............. 1450         0.22% 
OSM_AMENITY_Z16................................... 1440         0.22% 
IDX_OSM_BUILDING_LABELS_GEOMETRY_NODE............. 1332         0.21% 
OSM_BUILDING_LABELS............................... 1290         0.20% 

[rinigus]

use mapbox gl.