[ASK-help] Multiple Insert data get 504 gateway timeout - Printable Version +- CodeIgniter Forums (https://forum.codeigniter.com) +-- Forum: Using CodeIgniter (https://forum.codeigniter.com/forumdisplay.php?fid=5) +--- Forum: General Help (https://forum.codeigniter.com/forumdisplay.php?fid=24) +--- Thread: [ASK-help] Multiple Insert data get 504 gateway timeout (/showthread.php?tid=67165) |
[ASK-help] Multiple Insert data get 504 gateway timeout - izor - 01-23-2017 i have this code for multiple insert data and check data before insert, example i have 400 row data, and when i try to run this script PHP Code: //get data tenant from tipe utilitas when the proses, the data can insert to DB but the browser/application get "504 Gateway Time-out"; how i can optimize the application to be fast prosess and not get 504 error, thanks RE: [ASK-help] Multiple Insert data get 504 gateway timeout - InsiteFX - 01-24-2017 504 Gatetimeout is a HTTP Error not a database error. The database takes too long to collect your data. You probably have to increase max_execution_time in your php.ini Or you can try the CI database reconnect. PHP Code: $this->db->reconnect(); RE: [ASK-help] Multiple Insert data get 504 gateway timeout - izor - 01-30-2017 (01-24-2017, 05:45 AM)InsiteFX Wrote: 504 Gatetimeout is a HTTP Error not a database error. i try to change max_execution_time ini php.ini, still not working. still get 504 and the process still to long, RE: [ASK-help] Multiple Insert data get 504 gateway timeout - InsiteFX - 01-31-2017 A couple other things you can try: Code: PhpMyAdmin - phpMyAdmin\config.inc.php RE: [ASK-help] Multiple Insert data get 504 gateway timeout - spjonez - 01-31-2017 Your making too many queries in loops. Query all the data in a single statement, validate or format it in PHP, then insert. |