Submit Hint Search The Forums LinksStatsPollsHeadlinesRSS
14,000 hints and counting!

One possible fix for Safari freezes and slowdowns Web Browsers
I am syncing, on several Macs and several user accounts, information such as Calender, Mail Rules, Bookmarks, etc. After recently updating to Safari 4.01 and OS X 10.5.7, all of a sudden I had all very bad Safari performance -- including constant freeze situations. After being ready to delete the impacted user, I realized that there were some issues with the database.sqlite3 file in the Library » PubSub » Database folder. The PubSub folder is used for tracking RSS feeds, and it seems my problem resided there.

After deleting the database.sqlite file, and reseting the Mobile Me information, the freezes and crashes stopped. Hope this helps others, too.
    •    
  • Currently 2.58 / 5
  You rated: 4 / 5 (12 votes cast)
 
[43,976 views]  

One possible fix for Safari freezes and slowdowns | 11 comments | Create New Account
Click here to return to the 'One possible fix for Safari freezes and slowdowns' hint
The following comments are owned by whoever posted them. This site is not responsible for what they say.
One possible fix for Safari freezes and slowdowns
Authored by: rmanke on Jun 23, '09 08:34:50AM

Thanks for the tip... hopefully this helps!

Now, if only you could figure out why Spotlight does the same things, and keeps reindexing the external hard drive every time I restart... ;)



[ Reply to This | # ]
One possible fix for Safari freezes and slowdowns
Authored by: unforeseen:X11 on Jun 23, '09 09:31:24AM

Does anybody know what this Database.sqlite is used for? I don't use RSS from Safari, neither from Mail, and nevertheless I had 36'000 Authors in there...

---
this is not the sig you`re looking for.



[ Reply to This | # ]
This really helped.
Authored by: cvk_b on Jun 23, '09 09:45:29AM

I was starting to wonder why everybody was saying safari 4 was so fast. Like a curtain was lifted.

Thanks.



[ Reply to This | # ]
One possible fix for Safari freezes and slowdowns
Authored by: kitm on Jun 23, '09 10:28:43AM

wow, it does make a difference to speed. I deleted both database and feeds. Not sure if both helped or not.



[ Reply to This | # ]
One possible fix for Safari freezes and slowdowns
Authored by: palahala on Jun 23, '09 10:46:34AM
Makes me start to wonder if SQLite is the culprit on the Mac. Two other issues with bad SQLite performance on macosxhints.com: Speed up iPhoto '09 by vacuuming its databases and Speed up Firefox by cleaning up places.sqlite. Did anyone run into the same issues on Windows for example?

[ Reply to This | # ]
One possible fix for Safari freezes and slowdowns
Authored by: CaptDeuce on Jun 23, '09 12:49:04PM

I couldn't fail to notice that my first launch of 4.0.1 took a long time. I don't know how long; maybe hours. I have long history and RSS settings are... wow, one year (that's down from forever). Figuring that's what was being processed, I wasn't concerned.

After that it has been just fine. I wonder if what you people experienced was a problem with the building of that database.

---
"Where's my other sock?" - A. Einstein

[ Reply to This | # ]

One possible fix for Safari freezes and slowdowns
Authored by: pablorph on Jun 23, '09 06:40:55PM

Wow, Thanks for this. I have been blaming ATT dsl for this for a while.

I, like others, don't use RSS. What I did was to go to Safari prefs and removed RSS articles now (button on bottom or RSS tab). That helped me, and keeps me from digging in "deep ground".

Thank you, thank you again.



[ Reply to This | # ]
One possible fix for Safari freezes and slowdowns
Authored by: mchagers on Oct 05, '09 01:08:47AM

I found this specific tip (removing rss articles through the preferences panel) very useful. Even with Safari. 4.03 on Snow Leopard, the speed up is noticeable.
I found I had rss feeds set to be removed after 2 weeks, and simply opening a new window could take up to 20 seconds occasionally. Now, after deleting all feeds it's back to a about 1 second. Perhaps the other tips in this thread would speed it up even more, but this is a much simpler thing to do.
Thanks!



[ Reply to This | # ]
One possible fix for Safari freezes and slowdowns
Authored by: frudov on Jun 27, '09 12:49:57AM

Thank you!!! It already seems faster (only bounces once before launching), and it hasn't crashed yet (would often crash just on launching). Interestingly, it seems that most of my top sites have the blue star next to them (but not all...), as if they got reset. Seems related but a small price to pay.



[ Reply to This | # ]
One possible fix for Safari freezes and slowdowns
Authored by: dunos on Jun 30, '09 02:39:16PM

What do you mean "reset mobileme". Can you give more instructions?



[ Reply to This | # ]
Same Database.sqlite3 problem with 10.6.7
Authored by: jfaughnan on Jul 22, '11 08:51:14AM

I had the exact same issue with 10.6.7:

http://tech.kateva.org/2011/07/contact-sync-hell-brings-my-imac-to-its.html

Found this article by searching on the rather unique string:

~/Library/PubSub/Database/Database.sqlite3 vacuum

Really, this hint deserves more prominence.

---
--
John Faughnan
jfaughnan@spamcop.net
www.faughnan.com



[ Reply to This | # ]