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