I set FireFox to store my history for 90 days, and I think this is slowing down the AwesomeBar. I set it to store history for 45 days, but I don't know how to delete everything in my existing history older than 45 days.
Trimming your Firefox History
As a follow up to my previous post about how you can significantly speed up Firefox 3 by clearing your history log, here are some tips and tricks for people who, like me, do not want to vanquish their entire history log in one fell swoop.
One of the most useful and compelling reason to always keep a reasonable amount of history logged is because it powers your awesome bar. Every time you type a url into the bar Firefox searches your history to come up with a list of suggestions you can pick. In other words, clearing your history log means your awesome bar is gonna be pretty helpless for awhile.
However, the key thing to realize when trimming your history log is that Firefox chronicles EVERY nook and cranny of the web you so much as plant a toe on. This includes all your google searches, all your video searches, every image you open in your google image searches and every last email you ever read. You should be realizing by now that unless you are a very peculiar and hardcore user, there are at least SOME of all that junk that you will never need nor want to appear on your awesome bar. In other words, we can ditch some of those history without any noticeable penalty. So the next question is naturally : how do we isolate the parts of our history log that we don’t need?
This is a sticky problem of course, and how well you can do this depends on your own surfing habits. Fortunately Firefox 3 also comes packaged with a secret weapon - the awesome Firefox 3 library manager. This is a nifty tool shipped with Firefox 3 that lets you manage your browsing history and your bookmarks in a single, powerful interface. For our purposes, you can start it up either by hitting ‘Shift-Ctrl-H‘ or going to ‘History > Show All History‘.
Smart trimming with the Firefox library manager
So what is the use of this library manager? Well, among other things this tool has a reasonably powerful search function built in (see the textbox near the top?). With this search function and a little thought on our part, we can easily isolate certain types of history items and delete them off in one fell swoop. For example, if you want to delete all your google searches (I don’t personally find them useful anyway), you can type ‘google search?’ into the search form. What the manager does then is list every history item in your log which has both the keywords ‘google’ and ’search?’ in its url or title. This happens to correspond to the url structure of all google searches (and next to nothing else), so you should see all your google searches decked out like this :
Isolating all logged google searches
To delete all your google searches then, simply select all (ctrl-A) and hit delete. If you have alot of history stored, this may lag and take awhile. After that you’re done! You have just deleted hundreds of useless history entries (if you use google as often as me)!
In a similar manner you can delete off many different classes of history items, depending on which you consider to be useless. The trick is to identify some sort of recurring pattern (in title or in url) that can distinguish the type of history items you want to delete. Sometimes this is easy : for example if you want to delete all logs of you reading your gmail emails (which I personally think is utterly useless), you can simply search for “mail.google.com/mail” and et voila!
Isolating your email reading logs
Sometimes of course it may be a little more tricky. Here are some suggested keywords you can try:
What kind of junk accumulates most in your history log depends highly on your surfing habits, of course. You can get a clue of what sort of pages are occupying large portions of your history log by simply sorting the log according to the Location column. To do this, simply click on the ‘Location‘ column header.
Sort by Location for clues of what is occupying large portions of your history log.
Limiting the amount of history Firefox keeps
I mentioned in my earlier post that Firefox has a setting at Edit > Preferences > Privacy - “Keep my history for at least XX days”. It turns out that this is a ’soft’ limit and does not mean that your history will be deleted after XX days. We can set a ‘hard’ limit by messing abit with the Firefox config. To do this :
A more advanced alternative
It turns out that in Firefox 3, all history items (and bookmarks) are stored in SQLite databases. So people who are well versed in SQL and would like to perform more powerful queries to selectively delete your history items can try out this neat Firefox add-on called SQLite manager. IT functions as a GUI SQLite database manager much like PhpMyAdmin does for MySQL. To get to the appropriate database, simply launch the add-on (Tools > SQLite Manager), and select “places.sqlite” from the top-right drop-down list. Query as pleased from there The interface is pretty idiot proof.
In command line, you can try the following code in a
Please, first backup your profile in case. ;)
Just wait 24 hours! or you could close the browser (without saving tabs to cache (bookmark all tabs if required)) and then open it and and see if that worked.
"Today" option means delete history of current calendar day. Not last 24 hours.
For instance, you visit youtube at 23:50 o'clock and now 23:55. Open history -> Today -> you will see youtube. After that you visit superuser at 00:05 o'clock and now 00:15 already. Open history -> Today -> you will see only superuser but open history -> Yesterday -> you will see youtube. So if you chose Clear recent history in Firefox -> Today -> you will delete only superuser but youtube stayed.
If you have SQLite you can run this command: