'Re: [Kolab-devel] 10.000 events in a Resource Calendar'

[prev in list] [next in list] [prev in thread] [next in thread] 

List: kolab-devel
Subject: Re: [Kolab-devel] 10.000 events in a Resource Calendar
From: Alex Potter <alex () ap-consulting ! co ! uk>
Date: 2012-05-19 15:45:54
Message-ID: 4FB7C032.3090700 () ap-consulting ! co ! uk
[Download RAW message or body]

[Attachment #2 (multipart/alternative)]

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...

Maybe too resource intensive? Schema wouldn't support it?

Alex

[Attachment #5 (text/html)]

<html>
  <head>
    <meta content="text/html; charset=ISO-8859-1"
      http-equiv="Content-Type">
  </head>
  <body bgcolor="#FFFFFF" text="#000000">
    On 19/05/12 12:10, Jeroen van Meeuwen (Kolab Systems) wrote:
    <blockquote cite="mid:2434571.UjCGyu54rL@albert.kolabsys.com"
      type="cite">
      <pre wrap="">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,</pre>
    </blockquote>
    How about a database query?<br>
    <br>
    pseudo: if count (select event.timerange from events where
    event.timerange&nbsp; in newevent.timerange ) then... <br>
    <br>
    Maybe too resource intensive? Schema wouldn't support it?<br>
    <br>
    Alex<br>
    <br>
    <br>
  </body>
</html>

_______________________________________________
Kolab-devel mailing list
Kolab-devel@kolab.org
https://www.intevation.de/mailman/listinfo/kolab-devel

[prev in list] [next in list] [prev in thread] [next in thread] 