2010年4月15日

Firefox Place Cleanning for performance

Use PlacesCleaner 收藏庫清潔工 :: Firefox 附加元件 directly
or execute those commands one-by-one in Tools->Error Console by your hands:
Components.classes["@mozilla.org/browser/nav-history-service;1"].getService(Components.interfaces.nsPIPlacesDatabase).DBConnection.executeSimpleSQL("DELETE FROM moz_historyvisits WHERE place_id IN (SELECT id FROM moz_places WHERE visit_count <=2 );");
Components.classes["@mozilla.org/browser/nav-history-service;1"].getService(Components.interfaces.nsPIPlacesDatabase).DBConnection.executeSimpleSQL("DELETE FROM moz_places WHERE (visit_count <=2 AND hidden <> 1 AND id NOT IN (SELECT place_id FROM moz_annos UNION SELECT fk FROM moz_bookmarks));");
Components.classes["@mozilla.org/browser/nav-history-service;1"].getService(Components.interfaces.nsPIPlacesDatabase).DBConnection.executeSimpleSQL("DELETE FROM moz_inputhistory WHERE place_id NOT IN (SELECT id FROM moz_places);");
Components.classes["@mozilla.org/browser/nav-history-service;1"].getService(Components.interfaces.nsPIPlacesDatabase).DBConnection.executeSimpleSQL("DELETE FROM moz_favicons WHERE id NOT IN (SELECT favicon_id FROM moz_places);");
Components.classes["@mozilla.org/browser/nav-history-service;1"].getService(Components.interfaces.nsPIPlacesDatabase).DBConnection.executeSimpleSQL("DELETE FROM moz_annos WHERE anno_attribute_id IN (SELECT id FROM moz_anno_attributes WHERE name = 'google-toolbar/thumbnail-score' OR name = 'google-toolbar/thumbnail');");
Components.classes["@mozilla.org/browser/nav-history-service;1"].getService(Components.interfaces.nsPIPlacesDatabase).DBConnection.executeSimpleSQL("VACUUM"); 

Ref:
檢視主題 - Firefox 3 日漸肥大的收藏庫減肥法 • Mozilla Taiwan 討論區
Vacuum Firefox databases for better performance, now with no restart 

2010年4月13日

Disable Thread SMS in Window Mobile 6.1

Under HKEY_CURRENT_USER\Software\Microsoft\Inbox\Settings\OEM\ (create if not exist),
create a new DWORD named SMSInboxThreadingDisabled and set it to 1.

ref:
Disable SMS Text Message Threading or Conversation Mode in Windows Mobile 6.1

2010年4月11日

GIMP plug-in for content-aware resize

Liquid Rescale GIMP plugin: content-aware resizing for the GIMP
It is a free, open source frontend to the Liquid Rescale Library, which provides an implementation of the Seam Carving algorithm as described in this paper by Shai Avidan and Ariel Shamir.