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

Matthias Rebbe matthias_livecode_150811 at m-r-d.de
Fri Dec 29 17:36:30 EST 2017


Thanks Rick for sharing your thoughts.

I am just updating only one field in each record and i am not locking the record.
The complete update when doing one after one in a repeat loop does not take more than 1 second.
So i think i will go that way.

Thanks again.

Regards,
Matthias 

> Am 29.12.2017 um 23:19 schrieb Rick Harrison via use-livecode <use-livecode at lists.runrev.com <mailto:use-livecode at lists.runrev.com>>:
> 
> Hi Matthias,
> 
> Are there going to be users on your system at the time of the update?
> Are you locking the record or records before your update, and then
> unlocking them?
> 
> You should do a test with the repeat loop to see how long the process takes.
> If it is depriving your users of the database for too long you may want to
> think of a way which will impact their use the least.  Perhaps picking a
> time of day when your system is getting the least amount of traffic
> would be best.
> 
> Hope this helps.
> 
> Rick
> 
>> On Dec 29, 2017, at 3:53 PM, Matthias Rebbe via use-livecode <use-livecode at lists.runrev.com <mailto:use-livecode at lists.runrev.com>> wrote:
>> 
>> Hi,
>> 
>> i need to update regularly about 2000 rows/records of a MySQL table with Livecode Server.
>> 
>> What is better?
>> Executing the 2000 update commands in one take using revexecuteSQL
>> or should i execute one update command after each other within a repeat loop?
>> 
>> What do you think?
>> 
>> Regards,
>> 
>> Matthias 
>> 
>> 
>> _______________________________________________
>> 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




More information about the Use-livecode mailing list