Jump to content

This topic is 2015 days old. Please don't post here. Open a new topic instead.

Recommended Posts

For the "B64" container fields, what should our recommended storage options on those be? Without paying attention, I left it on the default of "Indexing / All" which was obviously a huge problem, but should I have "Do not store calculation results" checked? The reason I ask is my 2Gb DB doubled in size after adding these fields. 

Link to post
Share on other sites

Ryan --

 

To keep the file size down, I recommend using un-stored calculations. However, you'll take a performance hit, as FileMaker will need to handle the encoding on the fly. So it's a bit of a trade-off.

 

There are some additional suggestions regarding the handling of containers here:

http://fmeasysync.com/docs-easysync-integration/

 

-- Tim

Link to post
Share on other sites

Yep. I am already on board with the suggestions in the handling of containers. I've already change my users to use the FM camera on a Large or lower resolution.

 

I think I would rather have the performance hit at time of sync than have the database double in size on a device with limited space.

Link to post
Share on other sites
  • 3 weeks later...

Tim,

You mention this issue on your troubleshooting page:

 

Some synced containers are being corrupted. Why?
One possible explanation is that the values in the containers are being stored using FileMaker's "compress" option. There is a known issue with FileMaker's Base64 encoding function, where the function does not first decompress a container's contents prior to encoding. To avoid this problem, do not use compressed containers.

Note: This issue also applies to secure, external containers. FileMaker is not decrypting the containers before Base64 encoding them. As a result, decoding those values returns incorrect values.

 

Has there been any fixes for this? Currently, we are not using external storage at all on the hosted file because of this (secured or unsecured). Wim has strongly suggested not using non-secure external storage.

Link to post
Share on other sites

Thanks, Tim. If you have any creative ideas for managing lots of image data, please feel free to share! ;-)

 

We cannot leave all our images in this table. The least we can do is break it off into a separate file, but we're thinking beyond that to perhaps Amazon Web Services. However, we do have to remember our FMGo clients.

Link to post
Share on other sites

This topic is 2015 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.