Best way to update a large DB ?

[Mike Kerner]

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 at 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 at 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."