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] **********************************************************************
