Thread
:
[howto] fix calendar - calendar db file too big - calendar widget freezes hildon desktop or calendar opens slow
View Single Post
zamorph
2011-06-10 , 18:33
Posts: 62 | Thanked: 73 times | Joined on Jun 2010
#
4
I just wanted to say a big thank you to miniME - I had similar problems / symptoms - the Calendar Process would use 80% CPU for long periods - and my N900 would become unusable - flashing didn't solve the problem either.
Eventually, with the help of this thread, I used SQLite to view the calendardb file. It had grown to 395 MB!
I copied the calendardb file to /home/user/MyDocs (took a long time). I then connected my N900 to my computer via USB - copied the file to my computer - and viewed the contents with the SQLite Database Browser (
http://sqlitebrowser.sourceforge.net
).
I discovered that just 3 ComponentId's in the XProperties Table took up 10,485,760 rows! I deleted all of these.
I then saved and compacted the database (calendardb) - copied it back to MyDocs on the N900 - and then copied it back to /home/user/.calendar/calendardb (after I had made a copy of the original calendardb).
The Calendar, and my N900, seem to be working much better now!
I think the problem came about because I had previously migrated recurring Calendar Tasks from my old Nokia N78.
Quote & Reply
|
zamorph
View Public Profile
Send a private message to zamorph
Find all posts by zamorph