-
Please note: In an effort to ensure that all of our users feel welcome on our forums, we’ve updated our forum rules. You can review the updated rules here: http://forums.wolflair.com/showthread.php?t=5528.
If a fellow Community member is not following the forum rules, please report the post by clicking the Report button (the red yield sign on the left) located on every post. This will notify the moderators directly. If you have any questions about these new rules, please contact support@wolflair.com.
- The Lone Wolf Development Team
Is my loading time normal?
- Thread starter Farnaby
- Start date
How much content do you have entered. Realm Works takes a backup on login by default. If you have a slow hard-drive or lots of data this can take quite a bit of time.
There are options to reduce your database size and reduce / disable the backup on launch.
Obviously there is risk associated with turning this off completely but that's up to the user.
There are options to reduce your database size and reduce / disable the backup on launch.
Obviously there is risk associated with turning this off completely but that's up to the user.
Nope,
just started off, have 7 nearly empty databases and one where I have entered all Paizo feats and spells. The last backup is just 33 Mb.
Also after reading all the threads I installed it on a SSD.
Any way to change the backup/export directories to the SSD as well?
just started off, have 7 nearly empty databases and one where I have entered all Paizo feats and spells. The last backup is just 33 Mb.
Also after reading all the threads I installed it on a SSD.
Any way to change the backup/export directories to the SSD as well?
You can make the backups go to an SSD. You just need to make your user directories go on the SSD.
The simplest solution is to make the SSD your boot drive, you should do this if at all possible as running windows off an SSD will speed up your entire system. If that isn't an option you can still choose what drive your user directories go on.
This gives a step by step on how to move the user directories in Windows 10
www.dummies.com/computers/operating...e-the-location-of-user-folders-in-windows-10/
BTW are you saying it takes 11 minutes and 15 seconds for RW to launch? If so you have a serious issue. Could you post your system specs? Unless you are trying to run RW on the potato of all potatoes that is far too slow.
The simplest solution is to make the SSD your boot drive, you should do this if at all possible as running windows off an SSD will speed up your entire system. If that isn't an option you can still choose what drive your user directories go on.
This gives a step by step on how to move the user directories in Windows 10
www.dummies.com/computers/operating...e-the-location-of-user-folders-in-windows-10/
BTW are you saying it takes 11 minutes and 15 seconds for RW to launch? If so you have a serious issue. Could you post your system specs? Unless you are trying to run RW on the potato of all potatoes that is far too slow.
Well my OS is on a SSD and RW is installed on a 2nd SSD.
But I had the file size of my backup completely wrong it's 33 GB, not MB!
Something is really wrong. As I said, I only have really entered 1 realm seriously and that
has the Paizo feats and spells added per the csv2rw tool. No pictures or anything.
I'm going to delete everything and re-install. Sync the 1 realm and see what's happening.
-------------
App startup is now seconds.
Synced the realm and keep getting errors "Could not find a part of the path 'e:\Users\...\AppData\...'
An going to create a new realm and import the feats and spells again to see what happens.
But I had the file size of my backup completely wrong it's 33 GB, not MB!
Something is really wrong. As I said, I only have really entered 1 realm seriously and that
has the Paizo feats and spells added per the csv2rw tool. No pictures or anything.
I'm going to delete everything and re-install. Sync the 1 realm and see what's happening.
-------------
App startup is now seconds.
Synced the realm and keep getting errors "Could not find a part of the path 'e:\Users\...\AppData\...'
An going to create a new realm and import the feats and spells again to see what happens.
Last edited:
Not sure which CSV file you used but all the pathfinder feats and spells is a huge amount of data. It shouldn't be anything like 33 GB though unless you did the import several times or something.
I've told people this before and I'll say it again, I don't think there is much if any utility in adding all of that rules crunch to RW.
Ask yourself this, what links to all that stuff outside those articles and how likely are you to ever follow one of those links?
I've told people this before and I'll say it again, I don't think there is much if any utility in adding all of that rules crunch to RW.
Ask yourself this, what links to all that stuff outside those articles and how likely are you to ever follow one of those links?
I certainly would - if opening a new tab in RW wouldn't take longer than starting up a browser and navigating to site in question on the PFSRD...
I get where you are coming from but I am running a campaign and for the first time am in the higher (12+) levels. I cannot memorise the feats and spells and need to look them up during combat.
Do you have other suggestions? Like a different, faster app to look up spells and feats?
Last edited:
It is a known bug that doing imports generates wasted space in the database, which is why the "Compress database" option was added as a work-around.
This is my reasoning behind my realm.
I want a realm with the details of the Pathfinder Golarion campaign setting as well as the crunch. This I can take and export portions of it into my campaign realm as needed. E.g. Rise of the Runelords doesn't need anything apart from 2-3 lands. I don't need the rest.
So I started from scratch again and wiped every realm locally to have a clean slate, I uninstalled RW and deleted all the data apart from the structure and export files.
I created a brand new test realm, imported the structure and then imported the spells and feats. The following are the changes in the MASTER.REALM size after each step:
Start 5,040 KB
Global Data Sync 6,812 KB
Creating new realm 7,235 KB (pathfinder, structure file with 3 new categories)
Adding 9,828 KB export file with 2,777 feats 1,407,660 KB
Adding 16,166 KB file with 2,829 spells 3,986,780 KB
I have used and installed Lotus Notes back in the day and have a background in intercontinental networking as well as IT security. I mention this to prove that I know a bit about IT as a whole.
My question is how (insert random profanity here
) does the database expand from 7.2 MB to 1.4 GB and then 3.98 GB after importing 9 MB and then 16 MB text? No graphics, just a csv file created by using the csv2rw app.
And now here comes the really interesting part.
Seriously I did not expect this and I suggest everybody now should do it on a regular basis.
I went into tools under database management in the starting window and chose Compress Database. Even though I hadn't deleted anything, imported multiple times or do anything to cause bloat it reduced the MASTER.REALM down to 168.68 MB, which is still a about 130 MB more than expected, but a lot less then multiple GBs.
Despite my surprise, I have no problem with this, if RW works like this then okay. But I personally think this should be put in a prominent place so that everyone is aware of this and should do the compression on a regular basis.
And from a pure professional aspect, it would be interesting to know where the 130+ MB size comes from. The answer is going to be rational but I can't put my finger on it and that's annoying.
P.S. Thanks for all the replies, it's interesting to find out what more experienced users have realised.
I want a realm with the details of the Pathfinder Golarion campaign setting as well as the crunch. This I can take and export portions of it into my campaign realm as needed. E.g. Rise of the Runelords doesn't need anything apart from 2-3 lands. I don't need the rest.
So I started from scratch again and wiped every realm locally to have a clean slate, I uninstalled RW and deleted all the data apart from the structure and export files.
I created a brand new test realm, imported the structure and then imported the spells and feats. The following are the changes in the MASTER.REALM size after each step:
Start 5,040 KB
Global Data Sync 6,812 KB
Creating new realm 7,235 KB (pathfinder, structure file with 3 new categories)
Adding 9,828 KB export file with 2,777 feats 1,407,660 KB
Adding 16,166 KB file with 2,829 spells 3,986,780 KB
I have used and installed Lotus Notes back in the day and have a background in intercontinental networking as well as IT security. I mention this to prove that I know a bit about IT as a whole.
My question is how (insert random profanity here
) does the database expand from 7.2 MB to 1.4 GB and then 3.98 GB after importing 9 MB and then 16 MB text? No graphics, just a csv file created by using the csv2rw app.And now here comes the really interesting part.
Seriously I did not expect this and I suggest everybody now should do it on a regular basis.
I went into tools under database management in the starting window and chose Compress Database. Even though I hadn't deleted anything, imported multiple times or do anything to cause bloat it reduced the MASTER.REALM down to 168.68 MB, which is still a about 130 MB more than expected, but a lot less then multiple GBs.
Despite my surprise, I have no problem with this, if RW works like this then okay. But I personally think this should be put in a prominent place so that everyone is aware of this and should do the compression on a regular basis.
And from a pure professional aspect, it would be interesting to know where the 130+ MB size comes from. The answer is going to be rational but I can't put my finger on it and that's annoying.
P.S. Thanks for all the replies, it's interesting to find out what more experienced users have realised.
I use either HL or the PFSRD. Those are both way faster and easier than bloating RW with it.
As to your compress DB issues, 4 GB does seem excessive for just two imports. I'd really like to take a look at the script they use for inserting rows from a foreign source. I think something is hinky. The fact that you can run a utility and get 90+% of the space back says something is badly wrong somewhere.
Whether 130MB is really that large for the DB keep in mind a CSV is nearly as unformatted as data can be. A DB is a much more ordered method of storing data, one that usually relies on things like fixed record sizes and indexes to speed up searches both of which add bulk to the DB.
See, that was what I was missing, fixed length fields.
That comes of choosing networks over databases
I have noticed my loading screen (time it takes to double click the icon on my desktop until I get the "login" prompt has been really slow. I just timed it at 44 seconds. It has never been instant, but it never took this long until just recently.
My take is that this should not be related to the database size at this point in the process, or should it?
For the record, actually logging in, and loading a realm, take normal reasonable amounts of time. A few seconds.
My take is that this should not be related to the database size at this point in the process, or should it?
For the record, actually logging in, and loading a realm, take normal reasonable amounts of time. A few seconds.
Try compressing your database, it might have grown over time to something rather large. It needs to scan the database to get a list of realms.