Firefox 本身没有内建的访问历史记录过滤器之类的功能，所以那些每天访问频率很高但意义不大的URL地址会占据 places.sqlite 文件的大部分空间。当 places.sqlite 文件越来越大的时候，Firefox的地址栏就变得很卡，查看历史记录也是如此。如果只是把访问历史的保留天数改小的话，在提高了速度的同时也丢失了很多有价值的历史URL。

本来想找些扩展来达到类似的自定义过滤，结果只有找到一个 HistoryBlock 功能比较近似，可惜只是针对整个域名而不是通配符过滤，而且实现机制是去动态的删除历史记录里面的相关记录，比较影响Firefox的使用速度。看来看去还是根据自己的访问习惯写一段SQL来操作 places.sqlite 比较靠谱。

首先当然需要到这里下载一个对应版本的 sqlite 。在 windows 下要做的就是把down下来的 sqlite.exe 放到系统目录供后续使用。如果觉得命令行太麻烦的话 SQLiteExpert 是个不错的 GUI ，可以方便查看测试。

以下是 sql 脚本示例：

-- delete some specific url visit history records delete from moz_historyvisits where place_id in (select id from moz_places where ( -- google url like 'http%www.google.c%' or url like 'http%mail.google.com/%' or url like 'http://images.google.com/images?%' or url like 'http://blogsearch.google.com/blogsearch?%' or url like 'http://fusion.google.com/add%' or url like 'http://groups.google.com/group/%' or url like 'http://news.google.com/news?%' or url like 'http://%.friendconnect.gmodules.com/%' or url like 'http://video.google.com/videosearch?%' or url like 'http://googleads.g.doubleclick.net/pagead/ads?%' or -- other search url like 'http://www.baidu.com/%' or url like 'http://image.baidu.com/i?%' or url like 'http://ditu.baidu.com/%' or url like 'http://114search.%' or url like 'http://dict.yodao.com/search?%' or url like 'https://developer.mozilla.org/Special:Search?%' or -- local history url like 'http://localhost/%' or url like 'file:///%' or url like 'http://192.168.1.%' or -- taobao url like 'http%//auction%.taobao.com/auction/trade_%.htm%' or url like 'http%//member%.taobao.com/member/%' or url like 'http%//rate.taobao.com/remarkSeller.jhtml?%' or url like 'http%//search%.taobao.com/browse/%' or url like 'http%//trade.taobao.com/trade/%' or url like 'http%//taobao.alipay.com/trade/%' or -- tiny url url like 'http://bit.ly/%' or url like 'http://htxt.it/%' or url like 'http://tinyurl.com/%' or -- bbs and other garbage url like 'http://download.csdn.net/%' or url like 'http://%.163.com/%' or url like 'http://%.sina.com%' or url like 'http://%.qq.com/%' or -- some redirect page url like 'http://guide.opendns.com/?url=%' or url like 'http://item.feedsky.com/redirect.fcg/%' or url like 'http://login.live.com/login.srf?%' or url like 'dumb' ) ) ; -- delete some specific url records 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) AND ( -- google url like 'http%www.google.c%' or url like 'http%mail.google.com/%' or url like 'http://images.google.com/images?%' or url like 'http://blogsearch.google.com/blogsearch?%' or url like 'http://fusion.google.com/add%' or url like 'http://groups.google.com/group/%' or url like 'http://news.google.com/news?%' or url like 'http://%.friendconnect.gmodules.com/%' or url like 'http://video.google.com/videosearch?%' or url like 'http://googleads.g.doubleclick.net/pagead/ads?%' or -- other search url like 'http://www.baidu.com/%' or url like 'http://image.baidu.com/i?%' or url like 'http://ditu.baidu.com/%' or url like 'http://114search.%' or url like 'http://dict.yodao.com/search?%' or url like 'https://developer.mozilla.org/Special:Search?%' or -- local history url like 'http://localhost/%' or url like 'file:///%' or url like 'http://192.168.1.%' or -- taobao url like 'http%//auction%.taobao.com/auction/trade_%.htm%' or url like 'http%//member%.taobao.com/member/%' or url like 'http%//rate.taobao.com/remarkSeller.jhtml?%' or url like 'http%//search%.taobao.com/browse/%' or url like 'http%//trade.taobao.com/trade/%' or url like 'http%//taobao.alipay.com/trade/%' or -- tiny url url like 'http://bit.ly/%' or url like 'http://htxt.it/%' or url like 'http://tinyurl.com/%' or -- bbs and other garbage url like 'http://download.csdn.net/%' or url like 'http://%.163.com/%' or url like 'http://%.sina.com%' or url like 'http://%.qq.com/%' or -- some redirect page url like 'http://guide.opendns.com/?url=%' or url like 'http://item.feedsky.com/redirect.fcg/%' or url like 'http://login.live.com/login.srf?%' or url like 'dumb' ) ; -- clean some urls not been visited in last 30 days delete from moz_places where --hidden <> 1 AND id in ( select place_id from ( select place_id,max(visit_date) as mdate from moz_historyvisits group by place_id ) as c where c.mdate < strftime('%s',datetime('now','-30 days'))*1000000 ) ; delete from moz_historyvisits where place_id not in (select id from moz_places) ; update moz_places set visit_count=(select count(*) from moz_historyvisits where moz_historyvisits.place_id = moz_places.id); -- compress db file VACUUM;

把整个 sql 脚本存成文件，比如 /path/to/anywhere/my_places_clean.sql

再写一个批处理文件：

set startDate=%date% set startTime=%time% set sdy=%startDate:~0,10% set sth=%startTime:~0,2% set stm=%startTime:~3,2% set sts=%startTime:~6,2% cd /path/to/your/firefox/profile/ copy /Y places.sqlite "places.sqlite.bak.%sdy%_%sth%.%stm%.%sts%" sqlite3 "places.sqlite" <"/path/to/anywhere/my_places_clean.sql"

每次执行批处理就根据 sql 脚本的内容对 places.sqlite 进行垃圾清理并压缩，同时把原来的 sqlite 文件按时间戳进行备份。以上的sql过滤条件和批处理方式完全根据我自己的喜好设定，请在仔细阅读之后再CV执行，记得先备份好您的 places.sqlite 文件以免造成不必要的数据丢失。places.sqlite 数据库的详细结构说明和注意问题请参见 Mozilla Firefox 3 History File Format 条目。