On mysql.. can't you prebuild your multi-command transaction in a variable (with a beginning and ending to the transaction) and then use revexecutesql with a single call for the one big transaction?
On Fri, Dec 29, 2017 at 5:59 PM, Dr. Hawkins via use-livecode < use-livecode@lists.runrev.com> wrote: > 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 > _______________________________________________ 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
