Lone Wolf Development Forums  

Go Back   Lone Wolf Development Forums > Realm Works Forums > Realm Works Discussion

Notices

Reply
 
Thread Tools Display Modes
wurzel
Senior Member
 
Join Date: Mar 2013
Location: Germany
Posts: 153

Old March 6th, 2017, 07:40 AM
How does compression of the database work? I removed one realm and afterwards compressed the database. It took some time and then the database file was exactly the same size (~3.5 GB). Is it just an internal compression? Do I have to do something special to reduce the file size?


DM: Tol'Uluk - game system independent homebrew world (so far AD&D 2, D&D3.5, Fate, Pathfinder, D&D5)
Tools: RW, CC3+, CD3, DD3, HL
RL: Retired senior IT manager. Now just housewife, grandma and fantasy author.
wurzel is offline   #1 Reply With Quote
Acenoid
Senior Member
 
Join Date: Dec 2013
Posts: 688

Old March 6th, 2017, 09:29 AM
I thought it's a way to clean / reallocate space - like a defrag.

Maybe you are just using 3.5 GB?

Join the (unofficial) Realm-Works IRC Chat: #realm-works on the Rizon Network (https://wiki.rizon.net/index.php?title=Servers)
-> Browser Client: https://kiwiirc.com/client/irc.rizon.net
Acenoid is offline   #2 Reply With Quote
Silveras
Senior Member
 
Join Date: Aug 2010
Posts: 1,484

Old March 6th, 2017, 09:53 AM
If the one realm was small, it may not make enough difference to notice at the GB level.

I noticed while working with Imports that importing relatively small amounts of data (originally exported from my own database) caused the database file to grow to many times the actual needed size (8x, 10x, 16x). Compressing the database recovers this "empty" space. (So my 1.5 GB realm that had grown to 8.5 GB through export-and-re-import was shrunk back to around 1.5 GB again.)

The developers have noted in the release notes that this is primarily a work-around for the import size growth issue while they work on a more permanent solution.
Silveras is offline   #3 Reply With Quote
EightBitz
Senior Member
 
Join Date: May 2013
Posts: 1,387

Old March 6th, 2017, 11:30 AM
Quote:
Originally Posted by Silveras View Post
If the one realm was small, it may not make enough difference to notice at the GB level.

I noticed while working with Imports that importing relatively small amounts of data (originally exported from my own database) caused the database file to grow to many times the actual needed size (8x, 10x, 16x). Compressing the database recovers this "empty" space. (So my 1.5 GB realm that had grown to 8.5 GB through export-and-re-import was shrunk back to around 1.5 GB again.)

The developers have noted in the release notes that this is primarily a work-around for the import size growth issue while they work on a more permanent solution.
Yep. I imported a 6 MB file, and it grew my database by 1.2 GB. This was before the compression tool, so I compressed it in a round-about way. Syncing, closing RW, renaming the local DB file, then restarting Realm Works and syncing as if it were a new installation, rebuilding my local DB. Cut it down to about 290 MB.

But if you're not importing, I wouldn't expect to see much of a change.
EightBitz is offline   #4 Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -8. The time now is 09:21 AM.


Powered by vBulletin® - Copyright ©2000 - 2019, vBulletin Solutions, Inc.
wolflair.com copyright ©1998-2016 Lone Wolf Development, Inc. View our Privacy Policy here.