CalcBuilder Forum

calcbuilder_stats table over 500'000 records

User Silvio De Boni 2026-03-05 07:24:31

Hi
We're using the calcbuilder on the blechladen.ch website for which you did a lot of good work.
I realised that that the calcbuilder_stats table has meanwhile over 500'000 records.
Is there a way to clear that? Is that somewhere needed or is it as the name suggests just statistics?

Best regards

Silvio

Moonsoft support 2026-03-05 13:12:08

Hi,
yes, that table is just for recording statistics from the calculators, the recording has been kept to ensure compatibility with previous versions and calculators we know have some dependant code and actively use it. If its not your case, you can clear all records from the table, and if you upgrade to latest version, you can also disable further recording going to

System->global configuration->calc builder


Hope this helps, regards
Guillermo V.
Moonsoft Team

User Silvio De Boni 2026-03-05 17:23:19

Hi
Thanks, I still don't know if I can empty this table and what influence it has to the calcbuilder and hikashop products.
Should I just leave it untouched? I'm just a bit worried about the 500'000 records, and growing.
Best regards
Silvio

Moonsoft support 2026-03-06 08:51:17

Hi,
yes, you can empty this table. It stores the 'history' of the executions, so if you don't want to use this information for any custom/internal report, you can just remove all the rows. And if you don't want to add new records in the future, you can stop the recording with the new configuration flag.


Hope this helps, regards
Guillermo V.
Moonsoft Team

User Silvio De Boni 2026-03-06 14:15:04

Hi
Thanks. From what I can see we do not need this.

I do not see that configuration to stop new records anywhere. Where exactly would I find that?

Regards

Silvio

Moonsoft support 2026-03-06 14:18:14

Hi,
in the latest version, you should see a parameter to handle this at


System->global configuration->calc builder

Best regards
Guillermo V.
Moonsoft Team

User Silvio De Boni 2026-03-06 14:24:29

Installed latest Version for Joomla 5. I do not see any setting there.

regards

Silvio

User Silvio De Boni 2026-03-11 08:27:08

Can you please let me know where I find this setting?
regards
Silvio

Moonsoft support 2026-03-11 09:08:57

Hi,
we've been trying with different updates, coming from previous versions, and at the time we upgrade to version 5.4.0, the new setting appears. Please click on the tab 'preferences' at the same page you sent with the screenshot, and let us know the parameters you can find there.

Thanks, regards
Silvia Martín
Moonsoft Team

User Silvio De Boni 2026-03-11 09:13:53

HI
Thanks! Now i could find it.
So I turn this off as from what I understand we do not need it anywhere.

Regards

Silvio

Moonsoft support 2026-03-11 09:17:21

Ok, perfect, we close this ticket with this solution, please open a new one in case you have further questions.

Thanks, best regards
Silvia Martín
Moonsoft Team

...
Support/development

Perfect for small code changes or to correct any bug at your site

Buy now!
...
CalcBuilder

Create dynamic calculators

Buy now!