Hi Kirk, My understanding is that the external data will not be loaded, until it is "needed", e.g. Record is loaded (e.g input form) or programmatically loaded.
However, we found that storing blobs in external file had detrimental effects in certain cases. If you've got 1000s and 1000s of blobs, these are all stored as individual files on disk. When copying these files (e.g. doing a manual backup), it takes vastly longer than if the blobs are stored in the data file. We put everything back into the data file. Copying the files was a nightmare. FYI This is on Windows Might work differently on Mac Also, we previously stored all BLOBs in a separate related table, so we were sure they weren't loaded until specifically requested programmatically. However, this was quite awhile back, but we just never changed it. Randy Engle XC2 Software LLC I haven't used the 'store outside of datafile' option (text, object, picture fields) very often. I'm wondering about how 4D manages loading the records across the network. I know that if I query a table from a client and then load or display the selection of records the record data gets pulled down from the server to the client. Thus it's generally faster to use EOS to do the searching on the server and only have to load the specific records required. I'm wondering if 4D is optimized to not download the externally stored data unless it's required? ********************************************************************** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:[email protected] **********************************************************************
