Radio, Web and Free Software

Ticket #16 (accepted task)

Opened 6 weeks ago

Last modified 6 weeks ago

PublicController#feed is very slow

Reported by: alban Owned by: alban
Priority: major Milestone: milestone2
Keywords: feed Cc:

Description

According request-log-analyzer, PublicController#feed.html? is the worst controller action. View and database performances are very low.

--------------------------------------------------------------------------------
Request duration - by sum    | Hits |    Sum |   Mean | StdDev |    Min |    Max
--------------------------------------------------------------------------------
PublicController#feed.html [ |  268 |  4m47s |  1.07s |  1.02s |  0.06s |  5.51s

--------------------------------------------------------------------------------
View rendering time - by sum | Hits |    Sum |   Mean | StdDev |    Min |    Max
--------------------------------------------------------------------------------
PublicController#feed.html [ |  268 |  4m18s |  0.96s |  0.92s |  0.05s |  4.98s

--------------------------------------------------------------------------------
Database time - by sum       | Hits |    Sum |   Mean | StdDev |    Min |    Max
--------------------------------------------------------------------------------
PublicController#feed.html [ |  268 | 27.83s |  0.10s |  0.12s |  0.00s |  0.80s

Change History

Changed 6 weeks ago by alban

  • owner set to alban
  • status changed from new to accepted

The database part should be optimized by the changeset [cb93cb8c2391bcfdff4eefed378aa47f6a8ef266]. The view part is more difficult and may require a fragment/page cache.

Note: See TracTickets for help on using tickets.