[dev] Re: [cvs] commit: kronolith/lib Kronolith.php kronolith month.php

[Mike Cochrane]

After this and the caching in Perms, Shares, and Groups we're down to 32
database queries per month view with two calendars set to display. This was
previous >300 queries. 

The week view is currently 44 queries with the same calendars and events
visible. 42 for week view with the other 2 days queries missing.

25 for day view.

Also a couple of these quieries are for the alarm checks to, which, as i just
realized now, don't show the alarms for all the calendars being display so this
will be fixed soon :-)

- Mike :-)

> ----- Message from mike@graftonhall.co.nz ---------
> 
> mikec       2002/09/11 22:24:28 PDT
> 
>   Modified files:
>     lib                  Kronolith.php
>     .                    month.php
>   Log:
>   Add a function to reteive a 2 dimensional array events groups by the day
> they occur on.
> 
>   Use the above function in month.php to speed things up.
> 
>   Revision  Changes    Path
>   1.64      +118 -2    kronolith/lib/Kronolith.php
>   1.90      +6 -2      kronolith/month.php
> 
>   Chora Links:
>  
> http://cvs.horde.org/diff.php/kronolith/lib/Kronolith.php?r1=1.63&r2=1.64&ty=u
>   http://cvs.horde.org/diff.php/kronolith/month.php?r1=1.89&r2=1.90&ty=u
> 
> --
> To unsubscribe, mail: cvs-unsubscribe@lists.horde.org
> 
> ----- End message from mike@graftonhall.co.nz -----