and you can't do it locally? that isn't that many records. it shouldn't take long at all.
On Mon, Jun 13, 2022 at 4:31 AM jbv via use-livecode < use-livecode@lists.runrev.com> wrote: > Hi list, > > I have a mySQL DB with about 400000 entries, and I need to update > 190000 of them in the following way : > update myDB set col1 = "blah blah", col2 = "blah blah" where id = 12345 > limit 1 > > I have a file with all the requests that weights almost 200 Mb. > I can't upload it via phpMyadmin, because it's too big and running all > the requests > in one go will end up with a server timeout. > > I was thinking of a cron job that would trigger every minute or so, and > run a short > script that would read successive portions of 100 requests and feed them > so mySQL. > > Any better idea ? > Thanks in advance. > jbv > > _______________________________________________ > 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 > -- On the first day, God created the heavens and the Earth On the second day, God created the oceans. On the third day, God put the animals on hold for a few hours, and did a little diving. And God said, "This is good." _______________________________________________ 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
