Database size

John Es
2010-06-02
2013-11-17
  • John Es

    John Es - 2010-06-02

    My rssowl database is over 1.2 GB... even though I just cleaned up 50% of my
    news items.

    How can I defrag or compact this database?

    Thanks,

    John

     
  • John Es

    John Es - 2010-06-07

    Can anyone help with this (please)?.

     
  • Anonymous - 2010-06-08

    Tools > Clean Up. But the size issue will remain in 2.0.x and eventually to be
    looked at in 2.1.

     
  • John Es

    John Es - 2010-06-10

    Thanks -- but as you said, that option doesn't shrink the database.

    Any idea when 2.1 will be released? At this point, my hard drive is filled,
    pretty much and so my only options are to not use RSSOwl or delete all my
    news, etc.

    Do you know of an external tool or utility that can shrink this database (what
    type of DB is it)?

    Thanks....

     
  • Jorge Andres Brugger

    It uses DB4O database, with Lucene, AFAIK ...

     
  • Anonymous - 2010-07-01

    Yeap. There is no tool to shrink it.

     
  • John Es

    John Es - 2010-07-12

    Is there no tool to shrink./compact the database builtin to RSSOwl, or any
    tool for the database at all?

    I thought I saw references to a compact function at the website

    I can't imagine the use of a database (dbo4 project) that would just keep
    getting bigger. Indeed this issue has been written about here: http://develop
    er.db4o.com/Forums/tabid/98/aft/5045/Default.aspx

    1) I there any reason to not use something like mysql or sqlite?

    2) Is there a way to backup and restore the database but the restore bein
    gsmaller because it is not using the old unused objects?

    In a stand alone application using Db4o as a back-end you could defragment and
    backup the database upon application start once a day/week. -- as suggested
    here: http://developer.db4o.com/Forums/tabid/98/aft/3945/Default.aspx

    http://developer.db4o.com/Forums/tabid/98/aft/3945/Default.aspx

    I just really love rssowl, but it's at almost 2gb, and keeps growing and I
    dont know of a way to keep this on my machine too much longer...

     
  • John Es

    John Es - 2010-07-13

    The guys over at stackoverflow said this:

    "db4o Defragment will do what you want. You should run it with the RSSOwl
    sources in the CLASSPATH. You may like to ask the RSSOwl guys to include
    Defragment in their product. It's really easy for them. It's just 3 lines that
    they have to add to their code and one more menu item for their app"

    I am not a programmer but is there any chance of getting this into the next
    version?

     
  • Bzzz

    Bzzz - 2013-11-17

    bump.

    600 MB for an empty database, c'mon...

     

Log in to post a comment.

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:

JavaScript is required for this form.





No, thanks