On Fri, Dec 29, 2017 at 12:53 PM, Matthias Rebbe via use-livecode <use-livecode@lists.runrev.com> wrote:
> Executing the 2000 update commands in one take using revexecuteSQL > or should i execute one update command after each other within a repeat loop? Unless something has changed, you can't submit multiple mySQL commands at once from LiveCode, whether you immediately execute them or not. If the server is not local, you may find 2000 consecutive latencies to be brutally long (as in minutes, not seconds) You can, however, with postgreSQL and SQLite. In fact, it's a couple of insertions done as a singe transaction with SQLite every time I open a client, and a similar one to the posts server when I create a new one. -- Dr. Richard E. Hawkins, Esq. (702) 508-8462 _______________________________________________ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
