Exceed the speed limit
Last week I worked successfully on tuning and improving the performance of the reverse geocoding engine. We have used a tool, named K6 , to do some load tests. The test consists of doing massive requests to the service using a customized script to generate random geocoding queries all around the world. The first results showed a speed of about 200 queries/second as about 800K in an Hour. Working on tuning SQLite compile and configuration parameters we are able to surpass 1 Million queries in an Hour , about 300 geocoding queries/seconds. The decision to use SQLite than other DBs, like PostgreSQL, was deliberately done by design. There is a small presentation that explain this decision. We have also fixed a problem of instability of the service (crash), that emerged during the tests. We apologize to our users or customers (apparently no one 😇) for the abrupt interruption of the service caused by our stress tests. As I'm writing this text, a big load test of 24 hr is undergone... ...