Miyako, Nice explanation. More or less - where do you think the inflection point is where simple text concatenation becomes less efficient than adding the text to a BLOB?
On Sun, Jan 5, 2020 at 8:20 PM Keisuke Miyako via 4D_Tech < [email protected]> wrote: > concatenation of text is intuitive, but inefficient. > > every time you add text to another, a new buffer is created and the whole > text is copied there. > as the text gets larger, the allocation of memory and copying of data will > become slower. > > variable to blob is fast as it simply packs the variable. > I imagine you mainly use basic ASCII, compression would be really > effective. > I would not spend much time looking for the best compression algorithm or > level. > 200,000 elements / 2MB is too small to notice any difference. > > 2020/01/06 13:09、Mitchell Shiller via 4D_Tech <[email protected] > <mailto:[email protected]>>のメール: > > Obviously using the reverse commands to read from disk. > Option one seems by far the slowest. > > Anyone know if 2 or 3 is faster? > Does the COMPRESS BLOB help? The resultant file is about 2 MB in size > without compression. > If yes to COMPRESS BLOB , Any différence from native 4D vs. GZIP > compression? > > > > ********************************************************************** > 4D Internet Users Group (4D iNUG) > Archive: http://lists.4d.com/archives.html > Options: https://lists.4d.com/mailman/options/4d_tech > Unsub: mailto:[email protected] > ********************************************************************** -- Kirk Brooks San Francisco, CA ======================= What can be said, can be said clearly, and what you can’t say, you should shut up about *Wittgenstein and the Computer * ********************************************************************** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:[email protected] **********************************************************************
