Re: 10.000 events in a Resource Calendar

On 2012-05-19 16:45, Alex Potter wrote:
> On 19/05/12 12:10, Jeroen van Meeuwen (Kolab Systems) wrote:
>> To that end, I was wondering if there's a way to do this more 
>> efficiently
>> than;
>>
>> 1) Obtain*all*  event objects,
>> 2) Parsing*all*  of them one by one,
>> 3) Until I find a conflict or run out of events.
>>
>> Any thoughts would be appreciated.
>>
>> Kind regards,
> How about a database query?
>
> pseudo: if count (select event.timerange from events where
> event.timerange  in newevent.timerange ) then...
>

I reckon you are speaking of caching, which is fair but would need to 
be populated and maintained. This program I'm writing is executed 
against raw IMAP data for now, though.

> Maybe too resource intensive?

Caching obviously helps to reduce the resources and/or time needed to 
execute relational and comparative queries over IMAP, but it's not what 
I had in mind when I asked the question ;-)

> Schema wouldn't support it?
>

I'm not sure I understand what schema, if any, you are referring to.

Kind regards,

Jeroen van Meeuwen

-- 
Systems Architect, Kolab Systems AG

e: vanmeeuwen at kolabsys.com
m: +44 74 2516 3817
w: http://www.kolabsys.com

pgp: 9342 BF08