Drupal caches routes in
cache_data. This happens in
I am looking at a high traffic website with "interactive" search functionality based on a map. When you resize your window or move around in the map, a couple of requests are sent to the server for search results based on the map view.
Nearly all requests will be unique, because the map coordinates are part of the request parameters. This in turn seems to flood the
cache_data table. The
cache_data table easily grows with 100GB in an hour, so a lot of writes are taking place.
Consequently, the database is very busy.
- Is it possible to disable this caching?
- If #1 is not possible, is there a way to control the
cidof the cached routes? The route cache is essentially useless as it is now, as users never will get a cache hit. The possible combinations of query parameters are simply too big.