Hi Andreas,
--On July 2, 2007 2:22:44 AM +0200 Andreas Brodbeck <[EMAIL PROTECTED]>
wrote:
I have a test setup here, and I observe quite a long "calculation time"
for report queries. I have some few dates in the calendar, including
reccurent dates. It typically takes up to 500ms to give me a time range
for 30 days (equals to approx. 30 events) or so. (On a really fast
server machine). And for a whole year it takes up seconds...
How can I speed up this? What are the performance issues in general?
What is this load-balancing thing in the config file?
Any help is very much appreciated! (Thanks to Apple having this Calendar
Server open source!)
Can you describe exactly what the query is you are doing (i.e. send the XML
report body)? I would like to know if its just a time-range query or
whether it also does some text-matching. Also, I want to know whether you
are requesting the calendar-data to be returned with the report and whether
you are returning all the data or just part of it. The other question is
how large is the calendar you are targeting the report at? i.e. how many
resources in it?
Some things to note: a time-range only query should utilize only the sqlite
database and so ought to be fast. If you include any property/parameter
text searches then it will slow down a lot as currently we don't index
calendar text data - in that case the server has to open and search each
resources. Obviously that is far from ideal and we will be adding a lot
more indexing in the future to aid with that.
The other issue is returning partial calendar again - again to do that the
server has to open and parse each resource that is matched by the query,
and then write them up via a filter that only includes the selected
properties etc. Writing the entire calendar data is a lot easier - it just
streams the entire "raw" resource data from disk to the network. Whilst it
might be possible to utilize the index for the partial data case, a better
first step would be to optimize the iCalendar parser/generator.
--
Cyrus Daboo
_______________________________________________
calendarserver-users mailing list
calendarserver-users@lists.macosforge.org
http://lists.macosforge.org/mailman/listinfo/calendarserver-users
