MozillaZine

moz_annos in places.sqlite is getting bigger !

User Help for Mozilla Firefox
windhair

User avatar
 
Posts: 8
Joined: August 22nd, 2008, 2:12 am

Post Posted March 16th, 2009, 4:09 am

Recently, file places.sqlite getting bigger and bigger with surfing,
in which the table moz_annos increaes greatly with a long value in
"content" field. Mostly, "content" field has a value begin with
data:image/png, at follows by a long strange string.
Is this normal? and how to solve this problem?

Thanks

dickvl

User avatar
 
Posts: 52867
Joined: July 18th, 2005, 3:25 am

Post Posted March 16th, 2009, 4:45 am

That is the code for the site's favicon that is also stored in places.sqlite.
browser.chrome.site_icons (MozillaZine KB)
browser.chrome.favicons (MozillaZine KB)

windhair

User avatar
 
Posts: 8
Joined: August 22nd, 2008, 2:12 am

Post Posted March 16th, 2009, 5:10 am

Yes, you are right, but mon_annos is another table, i think it may related to some thing about the annotation, can it be disable?

windhair

User avatar
 
Posts: 8
Joined: August 22nd, 2008, 2:12 am

Post Posted March 16th, 2009, 8:18 am

Anyone has some idea about moz_annos in places.sqlite file? I find this table is getting bigger these days, in the places.sqlite, there is a table named moz_annos, in this table there is a field named "content". Mostly, "content" field has a value begin with data:image/png, at follows by a very very long strange string. Is this normal? FF runs slower than weeks ago, maybe this large part in places.sqlite (45M now) is the reason.

Image

Looks it is something related to the annotation, but I never use annotation with FF, is it possible to disable it?

Bluefang

User avatar
 
Posts: 7857
Joined: August 10th, 2005, 2:55 pm
Location: Vermont

Post Posted March 16th, 2009, 8:49 pm

No, you can't disable it. Annotations are used internally by Firefox. My guess is you have a misbehaving extension.

In the moz_anno_attributes, what are (id) 10 and 11 labeled as?
There have always been ghosts in the machine... random segments of code that have grouped together to form unexpected protocols. Unanticipated, these free radicals engender questions of free will, creativity, and even the nature of what we might call the soul...

windhair

User avatar
 
Posts: 8
Joined: August 22nd, 2008, 2:12 am

Post Posted March 17th, 2009, 1:38 am

The answer is coming closer, mon_anno_attributes 10 and 11 refer to the value google-toolbar thumbnail-score and URIproperties/characterSet , this seems related to google toolbar. in the option of googletool bar, there is a term which says a thumbnail will be generated for each page visited, I hope this is the reason, I will disable it and see whats going on then.

Thanks

windhair

User avatar
 
Posts: 8
Joined: August 22nd, 2008, 2:12 am

Post Posted March 17th, 2009, 1:44 am

Yes, it works, perfectly. no more thumbnail generated anymore, place,sqlite is around 2M now, without and rapid increasing.

Done

Return to Firefox Support


Who is online

Users browsing this forum: Google [Bot] and 10 guests