Best way to update a large DB ?
jbv at souslelogo.com
jbv at souslelogo.com
Mon Jun 13 04:30:34 EDT 2022
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
More information about the use-livecode
mailing list