Logging User Interactions Slowing Moodle?

Logging User Interactions Slowing Moodle?

by Carolyn Hodgman -
Number of replies: 1

Hi,

I previously posted this under General help but on reflection probably sits better here:

Our hosting and back end support provider has reported that as we are "logging user interaction for the whole year" it is slowing down performance of our Moodle installation so they have suggested we only log 3 months of data. They have not provided anymore specific detail than than and I can't get in to the back end and see what's going on.

Is this a performance issue anyone else has experienced? We would prefer to continue logging annual data. Would anyone have an alternative solution? Also has anyone had experience of a UK hosting and support provider's service in this way? I'd like to know if it's a common issue with this provider or just the way they are with us.

Thanks,

Carolyn.
Average of ratings: -
In reply to Carolyn Hodgman

Re: Logging User Interactions Slowing Moodle?

by Howard Miller -
Picture of Core developers Picture of Documentation writers Picture of Particularly helpful Moodlers Picture of Peer reviewers Picture of Plugin developers

It would be useful to know the version of Moodle?

The log tables can get incredibly large on a busy site and it has been known to have some performance issues (it's just the way databases work). I normally recommend keeping logs for a limited time - just to keep a lid on it. 

There's some talk of changing Moodle logging in a forthcoming version to log to files (which can be rotated by standard OS tools) which would offer a better solution. I don't know how definite that is. 

Average of ratings: -