multiget limit on a large calendar not enough

[Jan Bätzner]

Hi everyone,

i am trying to use a large (7000 Entry) Calender with Sunbird. It  
works fine with iCal but Sunbird seems to initialize the newly  
configured calender with one multiget command. It fails with an error:

2009-06-13 09:24:01+0200 [-] [caldav-8443]  [-] 'Too many results in  
multiget report: 7014'

I tried to simply change the limit in twistedcaldav/method/
report_multiget.py

max_number_of_multigets = 10000

That gives me the following error:

2009-06-13 12:50:49+0200 [-] [caldav-8443]  File "/usr/lib/python2.5/
site-packages/twistedcaldav/sql.py", line 246, in _db_execute
2009-06-13 12:50:49+0200 [-] [caldav-8443]    q.execute(sql,  
query_params)
2009-06-13 12:50:49+0200 [-] [caldav-8443] sqlite3.OperationalError:  
too many SQL variables

Well, that looks like a sqlite limitation. I cannot find out how to  
change that limit.
On the other side, i tried to find out, if it is possible to tell  
Sunbird not to use the multiget. Seems not an option.

Any Ideas how to get around this?

Thanks  in advance,

jb
--
Sumo Solutions
Jan Bätzner+Gollierstr. 23+80339 München
Telefon: [phone]
Fax: [phone]
Mobiltelefon: 0179 4973072

_______________________________________________
calendarserver-users mailing list
calendarserver-users@...
http://lists.macosforge.org/mailman/listinfo.cgi/calendarserver-users

[Helge Heß]

On 13.06.2009, at 13:07, Jan Bätzner wrote:
> Any Ideas how to get around this?


Split your calendar.

Really, its a bug in Lightning. It should fetch events in smaller  
batches for various reasons. We use a batchsize=32 for fetches  
triggered interactively and a batchsize up to 256 items for fetches in  
the background. This seems to be reasonable sizing (gives reasonable  
windows for user interactivity even during the calendar fetch).

Oh, and when the single large multiget is split into multiple, they  
could also check whether multiget is available at all and fall back to  
individual GETs if not :-) This way it might finally work with plain  
Apache.

Thanks,
   Helge
--
Helge Hess
http://zideone.com/
_______________________________________________
calendarserver-users mailing list
calendarserver-users@...
http://lists.macosforge.org/mailman/listinfo.cgi/calendarserver-users