Of the few things I dis\u00adlike about Fire\u00adfox 3, the his\u00adto\u00adry man\u00adag\u00ader (Places Library) is the worst. The UI fre\u00adquent\u00adly paus\u00ades for sec\u00adonds at a time when mov\u00ading up and down the list, delet\u00ading mul\u00adti\u00adple entries from the data\u00adbase is painful\u00adly slow and there\u2019s no progress bar. If an action blocks the UI for long enough a dia\u00adlog appears ask\u00ading whether you want to kill the cur\u00adrent script (includ\u00ading an inter\u00adnal path\u00adname and line num\u00adber!). It\u2019s not user-friend\u00adly and I don\u2019t have a clue what state that\u2019d leave the app in, so I hes\u00adi\u00adtate to do it.<\/p>\n
I had a hunch that the Places data\u00adbase was respon\u00adsi\u00adble for at least part of the slow\u00adness, along with my slow start-up times and occa\u00adsion\u00adal UI paus\u00ades when typ\u00ading in the address bar. So I went in search of a way to opti\u00admise the DB or fail\u00ading that cir\u00adcum\u00advent the Library UI and remove rows manually.<\/p>\n
I ran over a com\u00adment by \u2018olaf675\u2019<\/a> about using the SQLite Man\u00adag\u00ader addon<\/a> for FF3 to Com\u00adpact the Places data\u00adbase. This worked a charm, reduc\u00ading my places.sqlite file from 26MB to 13MB with no appar\u00adent issues after two restarts. This took about ~10 sec\u00adonds of processing.<\/p>\n I stepped into the Library again and removed ran\u00addom crap from his\u00adto\u00adry such as any\u00adthing end\u00ading in .jpg, Flickr pho\u00adto pages (flickr.com\/photos) and Google search\u00ades (google.com\/search). This totaled just over 6000 entries. Then any\u00adthing over 4 months old bit the dust (~1250). At this point remov\u00ading large num\u00adbers of entries was a lot faster. The Library is still not hang-free but it\u2019s a real improve\u00adment. Hope\u00adful\u00adly the Places UI work in FF3.1 will reduce freezes and pro\u00advide progress feedback.<\/p>\n","protected":false},"excerpt":{"rendered":" Of the few things I dis\u00adlike about Fire\u00adfox 3, the his\u00adto\u00adry man\u00adag\u00ader (Places Library) is the worst. The UI fre\u00adquent\u00adly paus\u00ades for sec\u00adonds at a time when mov\u00ading up and down the list, delet\u00ading mul\u00adti\u00adple entries from the data\u00adbase is painful\u00adly slow and there\u2019s no progress bar. If an action blocks the UI for long [\u2026]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"wp_typography_post_enhancements_disabled":false,"ngg_post_thumbnail":0},"categories":[1],"tags":[],"_links":{"self":[{"href":"https:\/\/xhva.net\/log\/wp-json\/wp\/v2\/posts\/54"}],"collection":[{"href":"https:\/\/xhva.net\/log\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/xhva.net\/log\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/xhva.net\/log\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/xhva.net\/log\/wp-json\/wp\/v2\/comments?post=54"}],"version-history":[{"count":0,"href":"https:\/\/xhva.net\/log\/wp-json\/wp\/v2\/posts\/54\/revisions"}],"wp:attachment":[{"href":"https:\/\/xhva.net\/log\/wp-json\/wp\/v2\/media?parent=54"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/xhva.net\/log\/wp-json\/wp\/v2\/categories?post=54"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/xhva.net\/log\/wp-json\/wp\/v2\/tags?post=54"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}