LC Server - MySQL - update about 2000 rows/records of a table
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
> 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:
More information about the Use-livecode