This DB is mostly used to retrieve all the street names for a given
city. Adding an index for the full_insee field greatly improves the
Without the index:
time $(echo 'select * from fantoir where full_insee="65054";' | sqlite3 fantoir.sqlite)
With the index:
time $(echo 'select * from fantoir where full_insee=65054;' | sqlite3 fantoir.sqlite)
$ time target/release/fast-fantoir FANTOIR0721
$ time target/debug/fast-fantoir FANTOIR0721
I highly suspect the release build to optimize out the useless file
read, partially explaining the *MASSIVE* perf difference between the
release build and the debug one.
This gives up a baseline speed order though. We should probably be
able to stay below 1 minute to generate the DB.