Performance issues (huge performance issues) in statistics

Bug #870186 reported by Marc Boivin
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
AuthPuppy
Confirmed
Undecided
Unassigned

Bug Description

With en average of 4300 daily connexions, generating statistics for more then 2 days is impossible.

The PHP thread running the repport doesn't use more then 300mb of memory but saturates the processor and blows past the 25 minutes max execution time without yielding any result.

Max PHP memory size: 1000mb

Revision history for this message
Marc Boivin (marcboivin) wrote :

Might be related to the fact the reports get returned and not outputted directly. I will try a dirty hack to output them and see if the performances get any better.

Revision history for this message
gbastien (gbastien02) wrote :

Check new version of statistics plugin 0.1.2

A new global statistics report was added and it may give you the information you require without using too much memory.

Since the other reports are connections reports, they shouldn't be used to retrieve info on thousands of data...

Changed in authpuppy:
status: New → Confirmed
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.