Skip Navigation

[Resolved] Exaggerated amount of Google API Geolocation requests

This support ticket is created 6 years ago. There's a good chance that you are reading advice that it now obsolete.

This is the technical support forum for Toolset - a suite of plugins for developing WordPress sites without writing PHP.

Everyone can read this forum, but only Toolset clients can post in it. Toolset support works 6 days per week, 19 hours per day.

Sun Mon Tue Wed Thu Fri Sat
8:00 – 12:00 8:00 – 12:00 8:00 – 12:00 8:00 – 12:00 8:00 – 12:00 - -
13:00 – 17:00 13:00 – 17:00 13:00 – 17:00 13:00 – 17:00 13:00 – 17:00 - -

Supporter timezone: America/New_York (GMT-04:00)

This topic contains 1 reply, has 2 voices.

Last updated by Christian Cox 6 years ago.

Assisted by: Christian Cox.

Author
Posts
#1171408
Captura de pantalla 2018-12-22 a las 1.51.07.png

Hello,

we have created a listing directory, available at hidden link

Although having only 937 posts with an address, we have every day a huge amount of API requests to de Geocoding Maps Service (8.641 requests in a week). Geocoding is the process of converting addresses (like a street address) into geographic coordinates (like latitude and longitude), which you can use to place markers on a map, or position the map.

Attached is an image that shows the numbers.

In our site, the API is only used by Toolset maps, and we understand that once the posts have obtained and cached the coordinates, Toolset Maps should not request again to convert the addresses to coordinates to google.

NOTE: We have a daily cron service that will search the custom posts, delete all of them via SQL query and replace them with the updated 937 post from our SQL server export main directory. In each replacement, only a few posts would have changed and the we can be sure that 99.9% of the addresses will not have change at all.

Is normal to see this amount of requests although the addresses have not changed?

Where do you think is the problem here?

I give you access here to two relevant things:

our site admin access (view credentials)

our phpmyadmin access (view in the ftp placeholders).

Thank you for your attention,

we understand that Toolset is a highly low cost resources optimized plugin, we want to clarify the issue,

thanks for the insight,

Best,

Mario

#1172060

NOTE: We have a daily cron service that will search the custom posts, delete all of them via SQL query and replace them with the updated 937 post from our SQL server export main directory. In each replacement, only a few posts would have changed and the we can be sure that 99.9% of the addresses will not have change at all.
Toolset stores cached geolocation information in a serialized data structure in the wp-options table. As long as the options table remains intact, the cached address geolocation information should remain available and the geolocation API should not be called again. However, if the options table is cleared or the data serialization structure is broken, the addresses must be geocoded again. Is the same API key used for your development site and the live site?