Page 1 of 1
database too big
Posted: Wed May 05, 2010 9:14 am
by romanichel
hello,
my UE database is more than 2Go.
Is it possible to make it less big?
I didn't find anything about in the UE functions.
Thanks by advance, for your help
Re: database too big
Posted: Wed May 05, 2010 4:11 pm
by jonib
First thing I would do is to check that any binary newsgroup uses the Compact binary database type. (To check rightclick on a newsgroup Advanced->Rename)
If it's still too big you need to limit the retention on big groups. Main menu->Edit->Properties->Newsgroups adjust the Retention/Dates [range] setting.
Hope this helps.
jonib
Re: database too big
Posted: Thu May 06, 2010 4:15 am
by alex
Maybe do you mean the size of the database folder?
Invoke edit menu->bodies, if you don't need any article bodies you can just select all entries and invoke "delete bodies" from the context menu (or simply press "Del").
If the size won't drop significantly it means those are headers, for example I have a newsgroup with 70M headers takes 2+GB disk space, most of that because of message-ids, it is about 28 bytes per part.
If you mostly use "import group" (nzb or search) you may try context menu > newsgroup > reset headers, the retention for that group (headers with higher retention are purged unless they are marked for download, flagged or have bodies) can be adjusted in edit menu->properties->newsgroups.
Re: database too big
Posted: Thu May 06, 2010 7:19 am
by romanichel
Yes, I spoke about database folder, that is about 2Go.
I already tried to make what you said (ie reset headers, retention range etc...) but the database is not more lower.
The only way I found for lower the database folder, is to delete some unused newsgroups.
In the database newsgroup the number folders have some .dat and .sdb files that are substantial size, but I don't know how I can lower those files.
Re: database too big
Posted: Thu May 06, 2010 10:37 am
by alex
Those files in the Newsgroups directory are headers, they should be kept somewhere, 2GB database size means that you have around 60-70M headers across all newsgroups.
When you invoke "reset headers" from the workspace (not from newsgroup) - if newsgroup is not loaded/open - the actual reset happens when you load or open newsgroup in the next time (since e.g. flagged headers are left untouched so the program cannot just purge all headers indiscriminately without going through all headers).
What is your purpose - do you want to keep less headers in the newsgroups (e.g. to reduce retention then you want to know how you can reduce the database size)? If you want to keep those headers they inherently take space.
After you have reduced the number of headers (lesser retention or header reset and then loaded/opened the newsgroup) - to compact the largest file in each newsgroup directory (cnt.dat) - in the workspace, the leftmost newsgroups pane invoke compact binary -> compact&free from the context menu, the rest of files are always kept at minimum size. If you keep the number of headers per group steady - compacting is not needed since the space is effectively reused.