Many SQL queries and Gateway Timeout

Question

I have simple query

UPDATE `local-cadastre` SET `name` = :district_name WHERE `id` = :uniq_id

But this query is repeated about 24000 times in foreach cycle, it works good but browser displays 504 Gateway Timeout error, is it possible to avoid this?

use a cronjob or setup the task in mysql – r3wt Apr 03 '14 at 06:05 — r3wt, Apr 03 '14 at 06:05

score 1 · Accepted Answer · answered Apr 03 '14 at 06:32

This problem related with network, due to slow IP communication.

If you do this task by a stored procedure then you can avoid this as stored procedures resides at server end. For it first put all your uniq_ids in a cursor (under stored procedure) then update one by one.

You can call this stored procedure either manually , by event in mysql or windows scheduler or cron job.

Many SQL queries and Gateway Timeout

1 Answers1