From Bug 721934 and GCP… relevant info from Places db in Firefox/Fennec


Here's the instructions on how to get the relevant stats from your places.sqlite file (in your profile). I'm interested if it took more than 2 minutes to get your profile migrated to Native Fennec. If you're using Sync (I presume everybody who encountered this bug is), doing this on your desktop profile might already be enough. Install https://addons.mozilla.org/en-US/firefox/addon/sqlite-manager/ Go to Tools (Press ALT to get the menu)->SQLite Manager Database->Connect New Database->places.sqlite Left Window->Tables->moz_bookmarks Right Window->Structure->More Info->No of Records <- note down Same for moz_favicons, moz_historyvisits and moz_places <- note down Right Window->Execute SQL Enter SQL: SELECT places.url AS a_url, places.title AS a_title, MAX(history.visit_date) AS a_date, COUNT(*) AS a_visits, favicon.data AS a_favicon_data, favicon.mime_type AS a_favicon_mime FROM (moz_historyvisits AS history JOIN moz_places AS places ON places.id = history.place_id LEFT OUTER JOIN moz_favicons AS favicon ON places.favicon_id = favicon.id) WHERE places.hidden <> 1 GROUP BY a_url ORDER BY a_visits DESC LIMIT 300 Complete bottom right: ET: xxxx ms <- note down Right Window->Execute SQL Enter SQL: SELECT places.url AS a_url, places.title AS a_title FROM (moz_places as places JOIN moz_bookmarks as bookmarks ON places.id = bookmarks.fk) WHERE places.hidden <> 1 ORDER BY bookmarks.dateAdded Complete bottom right: Number of Rows return: xxx ET: xxxx ms <- note down both
Advertisements

About shizen008

Breaking things and getting in trouble for it since '74. Disclaimer: I am not responsible if I make your head explode reading this blog! The writings here are my own expression and not of any companies. I currently work on being a QA for B2G aka Firefox OS
This entry was posted in Uncategorized. Bookmark the permalink.

One Response to From Bug 721934 and GCP… relevant info from Places db in Firefox/Fennec

  1. SELECT places.url AS a_url, places.title AS a_title, MAX(history.visit_date) AS a_date, COUNT(*) AS a_visits, favicon.data AS a_favicon_data, favicon.mime_type AS a_favicon_mime FROM (moz_historyvisits AS history JOIN moz_places AS places ON places.id = history.place_id LEFT OUTER JOIN moz_favicons AS favicon ON places.favicon_id = favicon.id) WHERE places.hidden 1 GROUP BY a_url ORDER BY a_visits DESC LIMIT 300

    that’s a long sql query 🙂 i’ll try it on my website at http://www.oyunsokagi.com

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s