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