[Tickets #13279] Improve caching of events in daily / weekly view

[noreply at bugs.horde.org]

DO NOT REPLY TO THIS MESSAGE. THIS EMAIL ADDRESS IS NOT MONITORED.

Ticket URL: http://bugs.horde.org/ticket/13279
------------------------------------------------------------------------------
  Ticket             | 13279
  Created By         | Thomas Jarosch <thomas.jarosch at intra2net.com>
  Summary            | Improve caching of events in daily / weekly view
  Queue              | Kronolith
  Version            | Git master
  Type               | Enhancement
  State              | New
  Priority           | 1. Low
  Milestone          |
  Patch              |
  Owners             |
------------------------------------------------------------------------------


Thomas Jarosch <thomas.jarosch at intra2net.com> (2014-06-20 14:48) wrote:

Hi,

one user reported a funny behaviour: When you have a calendar with  
lots of events (say 5.000+),
clicking through the daily / weekly view has a considerable delay - at  
least using a Kolab backend.

If you enter kronolith through the yearly view / switch once to the  
yearly view,
it's blazing fast even in the daily view.

-> So the yearly view builds up some cache that's re-used for the daily view.

It would be nice to build up this cache in the daily view, too.
One strategy would be to cache the events for the whole month of the  
current day.
Or current day +- 30 days.

That would make pagination in the daily view a lot faster.

Tested with the Kolab backend, but I can imagine the (client side?) cache
also avoids backend hits for the SQL backend.

Opinions?