Hi Kirk I just let you know my observation with 4D data stored outside the data file We stored a blob (pdf file) outside the data
In a table form (type output) the file outside the database is not loaded, and the rows to the screen is extremely fast In a project form we originally looped through the selection of data row by row and loaded to a listbox grid this was poor performing because the outside data got retrieved , even though i was never going to use it. (not sure if that just slowed the process on server side or if the data was sent to me from the server) (in my opinion it didn’t matter) This can be solved by either a SQL query specific the exact fields you want. or Run the query, and then use selection to Array (one caveat to this is that, the query will still load the First row, which means that record outside the database will be loaded at least to the server example of query with 2 column listbox (will columns objects named Title and Status) QUERY([Report];[Report]RunTimeStamp>=$lookupstamp) ORDER BY([Report];[Report]RunTimeStamp) SELECTION TO ARRAY([Report]ReportTitle;OBJECT Get pointer(Object named;"Title")->;*) SELECTION TO ARRAY([Report]ReportStatus;OBJECT Get pointer(Object named;"Status")->) > > Message: 4 > Date: Mon, 13 Feb 2017 06:58:47 -0800 > From: Kirk Brooks <[email protected]> > To: 4D iNug Technical <[email protected]> > Subject: Question about storing data outside of datafile > Message-ID: > <CAHY=xktgljw_m+llwsj4tapfkmw7kz8mznmgsq_3jtejmh-...@mail.gmail.com> > Content-Type: text/plain; charset=UTF-8 > > 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? > > Just to be clear let's imagine a table called [Documents]: > > [Documents] > > ID > > Title > > Date > > _body ( a blob field with the Store externally field property) > > From a client machine I execute an EOS search method that returns a named > selection and on the client display a form showing ID / Title / Date. > > Since the _body field isn't accessed yet is it true that data isn't > downloaded to the client? > > > -- > Kirk Brooks > San Francisco, CA > ======================= > ********************************************************************** 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] **********************************************************************
