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

Rick Harrison harrison at all-auctions.com
Fri Dec 29 17:19:17 EST 2017


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> 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
> 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