Hi,
By holding a lock. I don't know if this is the case
here, but it would
be an explanation. Are you using explicit transactions?
No.
But I will not
start it again - then there are just
no statistic updates anymore.
Please tell me what queries exactly the script performs. I'm pretty sure
this could be done more efficiently somehow - for example, by using at
the recentchanges table instead of revisions.
No, the recentchances does not help. For the statements, please
see "~aka/Cronjobs/UpdateDEUserStat.pl". The long running function
is called "GetUserCounts". Its pretty straight forward.
I already played with caches and so on, but this introduces other
problems. So, I have no idea how I can still further improve the
script without loosing functionality.
If you have an idea, please drop me a (private) mail, and you can
write in German then ;)
Regards,
Aka