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
Please visit this url to subscribe, unsubscribe and manage your subscription 

Reply via email to