search

Geta / geta-notfoundhandler

The popular NotFound handler for ASP.NET Core and Optimizely, enabling better control over your 404 page in addition to allowing redirects for old URLs that no longer works.
Apache License 2.0
20 stars 16 forks source link

Time out on suggestions/Not able to delete suggestions #107

Open QuirijnLangedijk opened 11 months ago

QuirijnLangedijk commented 11 months ago

Hi,

The suggestions page for one of our projects has grown so large that it's become impossible to load the page before Cloudflare times out. I thought that using the 'delete all suggestions' button in the settings would fix the issue, but it looks like the delete times out before deleting everything, since the page still times out after trying to delete 5+ times. By making a local copy of the db, I was able to find out that there are over 2 million suggestions, and while I added some redirects to stop it filling up so fast, Im still not able to clean all suggestions.

Is there any fix/workaround for this?

EDIT:

We ended up asking Optimizely to empty the entire table, since the 'delete all suggestions' didn't seem to do anything

kimjust6 commented 1 month ago

We are having the same issue...except we have 10 million entries. -_-. I suppose we will also have to ask Optimizely to empty the table.

Were you able to find a longer term solution with regards to this problem? or do we need to just request Opti to purge the info periodically.