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

Mike Bonner bonnmike at gmail.com
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 lists.runrev.com> wrote:

> 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
>
> _______________________________________________
> use-livecode mailing list
> use-livecode at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode
>



More information about the use-livecode mailing list