The PR allows providers to disable the creation of indexes when the table is created. It also adds an API for providers to create geohash, geometry, field indexes at will. If indexes are present when the table is created each successive insert will cause the full index to rewrite. Waiting until after the tables are written to add indexes significantly improves performance.
Goal: Significantly reduce DB CPU and Disk usage during data insertion.
[x] Use more efficient multi row inserts
[x] Make index creation optional at table creation
[x] Add index creation to external API
[ ] Use single index for Geohashes
[x] Bonus: Move touched logical groups into separate modules
The PR allows providers to disable the creation of indexes when the table is created. It also adds an API for providers to create
geohash, geometry, field
indexes at will. If indexes are present when the table is created each successive insert will cause the full index to rewrite. Waiting until after the tables are written to add indexes significantly improves performance.Goal: Significantly reduce DB CPU and Disk usage during data insertion.
[ ] Use single index for Geohashes