Hi GOTO SELECTED RECORD (or any ORDA equivalent of navigating record by record) will be slower than S2A but will take less RAM. That's based on actual experience.
Building up a single big text thingy will have RAM (and eventually potentially performance) issues if using straight string/text concatenation for each iteration. Because each time you add something to a string, a copy is made in RAM which is bound to lead to memory fragmentation and a higher workload for garbage collection. How significant is this? No idea. I've always avoided building up super-massive text as a single thing. We use GOTO SELECTED RECORD for building up SQL INSERT statements for sending to a (Microsoft or MySQL) server. We send the SQL text to the remote server every x iterations which makes it fairly slow going, but it keeps the RAM in reasonable control. Hope that helps. Best regards Keith White Synergist Express Ltd, UK. 4697775 ********************************************************************** 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] **********************************************************************
