search

dunkelstern / osmgeocoder

OpenStreetMap / OpenAddresses.io geocoder written in python
BSD 3-Clause "New" or "Revised" License
16 stars 1 forks source link

Average query times? #2

Open captainswain opened 5 years ago

captainswain commented 5 years ago

Hi there,

First off really interesting project! I couldn't find any contact information, so instead, I'm opening an issue. I was wondering what the average query time looks like for the project?

I'm borderline going to commit to running the scripts and importing the data, but before I do it I was wondering what performance I can expect.

My computer is rather slow so it would take me some time to import all the data.

thanks!

dunkelstern commented 5 years ago

Hi, Sorry for the late answer, i did not see the notification.

Query times depend on the direction of the Query:

GPS-Coordinate to Address is usually < 50 ms on a "normal Laptop", I reached 1.5 ms response times on a proper DB Server (hot caches, 32 GB Ram, 1 TB SSD, 8 core Intel Xeon 4GHz)

Address line to WGS84 Coordinate depends on the address itself and if you're using the AI address qualifier. Postal can do about 10k classifications per second easily, so i would recommend using it if you have unstructured data (e.g. just a string). If the address is complete or you have a reference point which is near the searched address the response time is between 100 to 500ms, if you reach the worst case the search can be as slow as 3 to 4 seconds. (Measured on the DB server).

Be aware this project is work in progress, the coordinate to address version is used productively for a project at anfema with about 150k queries per day and i would consider it stable. The other direction: address to coordinate is currently not in use.

dunkelstern commented 5 years ago

So I just updated the Forward Geocoding and it's much faster (and works now)! Be aware that version 2.0 of the geocoder has a different DB format, so if you already experimented with this you'll have to start over.

Query times:

Tested on:

Import of the Europe/Germany/Bavaria region from Geofabrik takes about 50 minutes.