Thanks to all. As i wrote already, i am updating now one row after the other using a repeat loop. MySQL is running on the same server as Livecode Server is. So it takes only one seconds or so to update all 2276 records.
Matthias > Am 30.12.2017 um 02:05 schrieb Mike Bonner via use-livecode > <use-livecode@lists.runrev.com <mailto:use-livecode@lists.runrev.com>>: > > 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 <mailto: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 <mailto: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 <mailto: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 <mailto: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 Matthias Rebbe Tel +49 5741 310000 https://matthiasrebbe.eu <https://matthiasrebbe.eu/> _______________________________________________ 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