XF 1.5 Daily Clean not works

[fingon]

I was found that DAILY CLEAN in cron is not working.
With execute DAILY CLEAN manually, the xf_search still have 12.7GB data.

Before:


After:

 

[Mike]

That table can be large as it stores 24 hours of cache results for searches and "find new" requests. Given that you appear to have over 30 million posts, I would assume you have a very busy board so while on the large side, I suspect you'll find the data is getting pruned daily.

 

[fingon]

That table can be large as it stores 24 hours of cache results for searches and "find new" requests. Given that you appear to have over 30 million posts, I would assume you have a very busy board so while on the large side, I suspect you'll find the data is getting pruned daily.

ehmm
For now I clean it manually in phpmyadmin.
Is there anyway to limit xf_search results like node thread list only shows 90 days/180 days/1 year etc?

 

[TPerry]

Personally, if I had that large of a post count, I'd seriously be looking at using ES add-on.

 

[fingon]

Personally, if I had that large of a post count, I'd seriously be looking at using ES add-on.

XF_SEARCH_INDEX TABLE?
I'm using ES.

 

[Mike]

There isn't a way to automatically limit the search date range -- it would likely require an add-on.