Junior Member
Join Date: May 2016
Posts: 9
|
Does anyone know how simple pictures are stored in the database? If I use the same picture on multiple topics are the stored as a byte field or dose the database save the file and store a reference to the file for each time the same file is added to the database?
|
#1 |
Senior Member
Join Date: Oct 2014
Location: Chicago, IL
Posts: 1,690
|
The image is stored separately every time its used.
my Realm Works videos https://www.youtube.com/channel/UCZU...4DwXXkvmBXQ9Yw |
#2 |
Senior Member
Join Date: May 2013
Posts: 1,458
|
You could create one topic with just the picture, then link to it from all the other topics that use it.
|
#3 |
Senior Member
Join Date: Mar 2014
Location: Germany, so please bear with my English
Posts: 378
|
Strangely this is accurate. I really don't know why rob chose to do it this way, instead of how the OP implies, but I'm sure he had a good reason to create such possible cause of database bloat and redundancy.
But yeah, I've been wondering this since I bought RW (2012-ish). |
#4 |
Senior Member
Join Date: Mar 2013
Location: Greater London, UK
Posts: 2,623
|
Quote:
Farling Author of the Realm Works Import tool, Realm Works Output tool and Realm Works to Foundry module Donations gratefully received via Patreon, Ko-Fi or Paypal |
|
#5 |
Senior Member
Join Date: May 2013
Posts: 1,458
|
Quote:
|
|
#6 |
Senior Member
Join Date: Oct 2014
Location: Chicago, IL
Posts: 1,690
|
Quote:
my Realm Works videos https://www.youtube.com/channel/UCZU...4DwXXkvmBXQ9Yw |
|
#7 |
Junior Member
Join Date: May 2016
Posts: 9
|
Quote:
Since RW is basically a structured intelligence DB - the ability of the users (aka players) to get the quick context from the picture snippet preview image is a high-value feature - really want that. I never use the map function - too hard to update during play sessions - so I use a combination of PowerPoint and MSPaint and a bulletin board to post game-day maps - But for my atlas-like content - its like buying a campaign resource - I just post the maps - zooming in to reveal detailed map content - for example - I might have a map of an island-dotted ocean and then a series of maps for each island cluster - and then use the island cluster map for each island in an island group as a well as the ocean map for context Since the meta knowledge of is in my head - I could use a custom snippet that took a link to a file stored in the DB once - typed checked to be a known image type - to the preview could process the image and make the icon - but the data was stored only once - I would know when to use either the Simple Picture Snippet or the Common Picture Snippet One side effect - good and bad - is that changing the reference picture would change the picture for all linked to it. Note Also: Although memory is cheap, load time is not. My time is the most expensive resource - the more time it takes to sync with the remote DB - the less time I am using the tool for content creation... Thanks for the info guys Later |
|
#8 |
Senior Member
Join Date: Oct 2014
Location: Chicago, IL
Posts: 1,690
|
What kind of hardware are you using that revealing a map takes a long time?
my Realm Works videos https://www.youtube.com/channel/UCZU...4DwXXkvmBXQ9Yw |
#9 |
Junior Member
Join Date: May 2016
Posts: 9
|
Sry - Poor word choice probably conflated a few issues
1) my gaming group does not use the smart map feature at all (the big fog of war thing) because we could not figure out how to use it effectively at the game table - instead its faster and easier for me to make a "cropped" or "overlayed" picture from a ppt file and post that to a bulletin board to incrementally reveal a map for gameplay 2) when I draw atlas maps - I draw large scale maps and then zoom in to reveal more detail in the atlas data. using MSPaint and screen captures I make png files of the maps at various scales - then I add the png files as simple pictures to the tabs where the map content enhances the other content 3) I have not checked the size of my DB recently - I have a $900 office rigged laptop - synchronization and loading to/from the RW offsite storage take about 10 minutes now. My players complain about longer synchronization times because they don't update as frequently as I do. Without measurement - this 10-minute wait seems longer to me than it last year - before I started adding content more heavily. |
#10 |
|
|