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

[Dr. Hawkins]

On Fri, Dec 29, 2017 at 12:53 PM, Matthias Rebbe via use-livecode
<use-livecode at 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