[CalendarServer-users] 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: 089 38164965
Fax: 089 66652870
Mobiltelefon: 0179 4973072