LC Server - MySQL - update about 2000 rows/records of a table

Mike Bonner bonnmike at
Fri Dec 29 20:05:45 EST 2017

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 at> wrote:

> On Fri, Dec 29, 2017 at 12:53 PM, Matthias Rebbe via use-livecode
> <use-livecode at> 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 at
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:

More information about the Use-livecode mailing list