multiget limit on a large calendar not enough
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: 089 38164965 Fax: 089 66652870 Mobiltelefon: 0179 4973072
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/
participants (2)
-
Helge Heß
-
Jan Bätzner