Nagasaki Posted February 27, 2007 Share Posted February 27, 2007 I heard that using embedded images will bog down a database and slow it up. Right now I only have about 500 records in my organization's db, but its going to grow, so definitely I am concerned about this. Some people in my industry use a type of database software where you can store the image in a spreadsheet and have the program grab that image. Is something similiar possibly in filemaker and will that save my database from a sluggish fate? Link to comment Share on other sites More sharing options...
Nagasaki Posted February 27, 2007 Author Share Posted February 27, 2007 Also, I forgot to add, if I already have 500 records with embedded images, is it going to be a huge pain to change that to a calculation that fetches it from another folder? Link to comment Share on other sites More sharing options...
mr_vodka Posted February 27, 2007 Share Posted February 27, 2007 If you are talking about container fields storing the images or simply referencing them, then yes eventually the size of the file will slow down your solution. If your solution is on a Peer to peer or preferablly server then every client could have a shared universal directory or path. The files would be located at this location for everyone. Then your container field would reference the path of the image instead of storing it. (checkbox "store reference only"). As for taking what is currently in your system and then converting them to reference them, you could write a script that would export them to the location path and then import/insert the image into the container field again but this time as reference only. Link to comment Share on other sites More sharing options...
Nagasaki Posted February 27, 2007 Author Share Posted February 27, 2007 I thought so, thank you very much for clarifying that for me. Link to comment Share on other sites More sharing options...
Genx Posted February 27, 2007 Share Posted February 27, 2007 ... OR, create an additional FileMaker file specifically for the storage of images and reference that from your main file. Link to comment Share on other sites More sharing options...
IdealData Posted February 28, 2007 Share Posted February 28, 2007 Nice try Genx, but wouldn't the images still be embedded in A FMP file? Then that file would hit performance problems. Link to comment Share on other sites More sharing options...
Lee Smith Posted February 28, 2007 Share Posted February 28, 2007 Hi Mr V and Mr ID, I've seen what you have pointed out before, but I've never seen this expressed by FileMaker. The only caution I see in FileMaker's Help is that [color:blue]Because image files can be large, consider importing only a reference to each image file, which I've always took to mean that you need to worry about the size of your FileMaker file and it's size limitations, not that it meant a slower performance of your files. And, now with the increase in FileMaker file size limits, this concern would seem to be minimized. My personal experience is limited to one small solution of about 4000 images, that 2 other files use via relationship. I have not experienced a performance hit that I can tell. I have been using this same file for many years, and have converted it twice (4, and 5). However, I have hesitated moving it up to v8.5, until I can decide if this wouldn't be a good time to export the images, or not. So, If any body can provide a link to additional information on this topic (i.e. performance test, white papers, etc.), it would be appreciated. TIA Lee Link to comment Share on other sites More sharing options...
Genx Posted February 28, 2007 Share Posted February 28, 2007 Nice try Genx, but wouldn't the images still be embedded in A FMP file? Then that file would hit performance problems It seems everyone just assumes performance problems... But i would definitley never mix the images and data, and i'd hesitate to use the FM file not because of Performance issues but rather for fear of corruption of the images themselves. Link to comment Share on other sites More sharing options...
Steverino Posted March 2, 2007 Share Posted March 2, 2007 Is there a way perhaps to store files and pictures on the web (upload and download), rather than in the file itself? Can you do that with the web viewer? Does anybody have a sample solution? I'm really looking for a solution to store a variety of files -- and my users might not have a network drive accessible. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6264 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 accountSign in
Already have an account? Sign in here.
Sign In Now