Why are these two files so large?

[dev77]

The "job" and the "`scheduled_job_log_record" tables are 10.2 MB and 8.2 MB on my MySQL database.

Is there any reason that EspoCRM has to keep all of these records in each file? Is there a way to 'optimize' them?

The third largest file is "meeting" and that is only 400K.

I tired the 'rebuild' option in Administration but that did nothing.

Is there a reason these files need to be so large? It sure slows down my backup scripts.

[item]

at this "tempo", you are going to need a data center

[dev77]

I don't know about a data center, but the files are larger than I think they have to be. Maybe I could truncate these files to a more manageable size? I'm also not sure what role they play in the system. Perhaps one of the developers will comment on this topic.

[yuri]

10Mb is extremely little. I though you mean Gbs first. Check Espo\Classes\Jobs\Cleanup. Jobs and scheduled jobs are stored at least for 10 days by default. cleanupJobPeriod parameter can be set in config.php.

[dev77]

I changed from 1 month to 'cleanupJobPeriod' => '1 day', and that reduced the files down to around 500K which is a long way from 10MB!

What do these two items affect:

'cleanupActionHistoryPeriod' => '15 days',
'cleanupAuthTokenPeriod' => '1 month',

[espcrm]

I wonder if this is what might cause my system to slow down (Loading...) when I do email search sometime... instead of reducing the time, I increase the time so I can save the logs for archival. I increase it to 300 days I think.