Do more on the web, with a fast and secure browser!

Download Opera browser with:

  • built-in ad blocker
  • battery saver
  • free VPN
Download Opera

Opera (15-26) gets very slow as Sessions.db gets large

  • Did you file a bug report somewhere?

  • Yes, I did. The black hole that is...

  • OK. Did you fix it or move to a different browser or something?

  • Neither... Every several days I delete the session.db, using the "Download Chrome Extension" and "Session Buddy" plugins (mentioned above) to restore my tabs. That buys me several more days of smooth sailing.

    Hopefully the devs take my bug report seriously, and fix this thing. It's blatantly reproducible, on a couple different machines I use. I've been using Opera since the beginning, and I really don't want to have to switch.

  • Ah ok thanks. I am having the same problem. I have just been deleting session.db and then letting it recreate.

    Edit: Which I've just realised doesn't save my tabs. Nevermind

  • I can't recommend Session Buddy enough. You really should try it. Its a much better way to save your tabs, especially if Opera or your system crashes.

  • Session Buddy will save your tabs. So the workaround goes like this...

    • Have "Download Chrome Extension" and "Session Buddy" plugins installed.
    • Have Opera running.
    1. Go to Session Buddy, and save your session.
    2. Close Opera.
    3. Delete the following files, manually (Win7):
    • C:\Users\YOURUSER\AppData\Roaming\Opera Software\Opera Stable\session.db
    • C:\Users\YOURUSER\AppData\Roaming\Opera Software\Opera Stable\session.dbak
    • C:\Users\YOURUSER\AppData\Roaming\Opera Software\Opera Stable\session.db-journal
    1. Reopen Opera. All tabs will be gone.
    2. Go to Session Buddy, and restore your saved session. It will restore all tabs, including pinned tabs.
    3. Use Opera for a few days, until it gets slow. Go back to Step 1.
  • Have you tired disabling 'Continue where I left off' in the startup options? As I said above I don't even have any sessions files and I think its because I don't use that feature. Yeah, it needs to be fixed by the devs but at least you wont have to close Opera all the time till the do track down the problem.

  • No, because that is an extremely important part of how I want to use Opera/browsers.

  • I'm on the verge of abandoning Opera for this reason.
    Once the file gets large enough, Opera becomes pretty much unusable. I've been getting by using Session buddy and deleting session.db file and that work for a time but its not long before the file has grown large enough to become a problem again.

  • Hi,

    Sorry to ask this but what is a session

  • @krrish1379 Its basically a save of every window and webpage you have open. So, when you open a previous session, it opens all of the webpages in one go. Its a feature Opera 12 had built in and its very handy for picking up where you left off. Currently it does it if you have Continue where I left off in the settings, but that only works when closing and reopening the browser. Extensions like Session Buddy can save and open sessions at any time and even keep several sessions saved at once.

    @gregdray Just out of curiosity, what OS are you running and how much RAM do you have?

  • @lando242 Thank you for the explanation. Can you explain & help me out on this post & is there any way to chat among members.

  • @lando242 Windows 8.1 Enterprise with 8gb of Ram.
    I deleted the session.db file and restore my tabs this morning and already the file is back up to 79mb. I'm not sure at what size it starts to get noticeable but its somewhere around 130mb or so, most noticeable when scrolling in web pages.

  • Instead of just deleting the session file have you also tried changing the 'On startup' option to something other than Continue where I left off? I use Session Buddy for all of my session needs and just have its management page set as one of the pages it opens when I start the browser. That makes it super easy to pick up where I left off even if the browser crashed. Which, to be fair, hasn't happened at all since they fixed that Ctrl+F bug in the Dev channel awhile back.

  • I have the same problem too. I am someone that could be called as "heavy user". Normally I don't close Opera in days and I use to have an average of 15+ tabs opened at the same time.

    I'm noticyng laggy from some time, maybe months. When I first realise it, I restarted opera (and all the opened tabs) but was the same. I tried closing all the tabs but surpresively still was laggy. It was specially noticiable in videos, that every 10 seconds aproximatedly has a "micro stop". That happens with all the videos, all the websites in flash or html5 and for example in Firefox with the same opened tabs it doesn't happens.

    I just did the same that "guido11x" and renamed the Opera Next folder in %Apdata% and it worked flawlessly so probably the problem is inside, i don't know.

    My specs are: Intel i5-2500k, 16GB Ram, SSD and AMD 6850HD in Windows 8.1 up to date and the latest Opera Next

  • hi everybody,

    I've been having this problem with Opera since some recent versions.

    My system is:

    Windows 8.1 64 bit

    8GB RAM

    So let's strike out possible system's problem/requirement, since since we all know Opera SHOULD run fine on everybody's specs here.

    Let's also agree that we would like Opera to start and open up tabs from previous sessions, I believe this is an important feature that none of us would want to compromise.

    After a lot of tests, deleting/recovering, disabling/enabling and so on, I've come to the following 'preliminary' assumptions:

    • Symptoms: noticeable lags when opening and closing tabs, playing video, typing, scrolling

    • The session db seems to be unrelated to saved browsing data and history, since cleaning up Opera's browsing data (Ctrl+Shift+Del) doesn't help.

    • Even after deleting site data - cookies and so on - the problem still persists.

    • There seems to be no difference between pinned and unpinned open tabs

    • Disabling all extensions doesn't help, so it's not their fault that Opera lags.

    Possible solutions:

    • Deleting session.db and session.dbak. I tried leaving the journal file and haven't seen and unwanted effect, so just let it be...

    • As mentioned, disabling extensions doesn't help when Opera is already lagging and session is already big, BUT disabling certain extensions, such as Autopagerize (all sites concerned) seems to slow down the expansion of this session file.

    This leads me to believe:

    • Maybe there's a bug in Opera that doesn't simplify/decrease this session file, leading to expand in size and as a result, slows down Opera.

    • Maybe some extensions help to worsen this bug, adding more stress to the file.

    • It seems that as long as session.db maintains its size under some MB (preferablly under 1MB), Opera runs fine. So keep an eye on your file.

    Please share your experience on this issue and also maybe solution too.

    Thanks everyone.

  • It looks like this issue isn't just a problem in Opera for Windows. It's the same for me with Opera 29 for Mac.
    Things generally get worse and worse until you start again with new session files. It's making Opera almost unusable at the moment.

  • All browsers fail at some point, be it IE, Firefox, Chrome, Safari and the one I use now, Opera.
    It builds and builds and builds. After navigating only 3 or 4 websites it starts to slow.
    Gets slower and slower the more you use it.
    Forget having more than 4 tabs open. It doesn't like that at all.
    Go to Facebook and don't expect any of the other tabs to open whilst you go and grow a tea plantation and collect the leaves and make a cup of tea.
    Nothing cures it.
    All I can do is logout and login to Opera again.
    Then the same happens.
    I use Vista and download speed is 7 meg. 1gig mem, 160 gig HD.
    Obviously something somewhere is grabbing the CPU for god knows what.
    I refuse to go round deleting stuff anywhere just because the Opera code is at fault.
    Opera, you fix it or be doomed to the discard pile of failed browsers.

  • 1 gig of memory on Vista? OUCH! Thats like 1/4th of what you need for that OS. RAM is cheap now, bump that guy up to 4 gigs and your life will be so much better. With only a gig of RAM your system will be making heavy use of the swap file on your hard drive and that is a lot slower than RAM. The more programs/windows/tabs you have open the more you use that swap file and the slower your system will get.

    As for having a bunch of tabs open I currently am rocking 5 windows (4 normal, 1 private) with a total of 29 tabs across them. I regularly jump to 6-7 windows and hundreds of tabs when doing something. My system was last rebooted on the 29th of August and Opera has been running continuously since that time. I regularly run it much longer than that without issues (had to reboot for Windows Updates). I'm using Windows 8.1 but I did the same stuff with Opera on Windows 7.

Log in to reply