Bernd, Thanks for the report, it's interesting and believable. In this case, I have to get the data into memory to send it... I guess I could write to a file, load that and then send it. Interesting concept, thanks!
On Mon, Sep 17, 2018 at 4:53 PM Bernd Fröhlich via 4D_Tech < 4d_tech@lists.4d.com> wrote: > David Adams: > > > I'm checking for the simplest, least difficult default as that should > work in the vast majority of cases. > > > Here are my two Eurocents: > it does not matter how you collect the data, but concatenating the text in > memory vs. writing to a file makes a HUGE difference when you have lots of > records. > > I have a method in my toolbox that writes out a selection or a whole > table into a file. > Looping through the records and appending each record to a file. > Works great. > > Then I did the same but instead of writing to a file, I appended to a > textvariable. > Works well for small amounts of data but is unusable for more than about > 20000 records as it slows down ever more. > (I am lazy and did not do any pre-sizing, chunking, whatever.) > > So if you want to export the data anyway and look for the simplest way, > then just loop through the data and write into a file. > > Greetings from Germany, > Bernd Fröhlich > ********************************************************************** > 4D Internet Users Group (4D iNUG) > Archive: http://lists.4d.com/archives.html > Options: https://lists.4d.com/mailman/options/4d_tech > Unsub: mailto:4d_tech-unsubscr...@lists.4d.com > ********************************************************************** ********************************************************************** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **********************************************************************