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