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

[Matthias Rebbe]

Thanks to all.

As i wrote already, i am updating now one row after the other using a repeat loop. MySQL  is running on the same server as Livecode Server is. So it takes only one seconds or so to update all 2276 records.

Matthias


> Am 30.12.2017 um 02:05 schrieb Mike Bonner via use-livecode <use-livecode at lists.runrev.com <mailto:use-livecode at lists.runrev.com>>:
> 
> 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 <mailto: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 <mailto: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 <mailto: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
>> 
> _______________________________________________
> use-livecode mailing list
> use-livecode at lists.runrev.com <mailto: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

Matthias Rebbe
Tel +49 5741 310000
‌https://matthiasrebbe.eu <https://matthiasrebbe.eu/>‌