Dear Friends,
I am working on a project of php, mysql, i am getting data from the xml and inserting in database table through making an array from the xml data, everything is perfectly working and data can be inserted into database but the problem is that xml has 3000 records but in database table mysql not inserting the accurate records, if oftenly insert 738 records, oftenly just 11 records or just 600 records not giving the accurate result
please help me, is it any mysql execution problem?, how can i remove that issue?
waiting for your help.
Thanks and Regards
MYSQL Execution Issue
Moderator: General Moderators
Re: MYSQL Execution Issue
Maybe your script gets terminated, for example because of max execution time or memory limit. Best show your code
Also, I bet you are performing INSERT INTO(...) VALUES(...);
inserting multiple values at once - INSERT INTO(...) VALUES(...),(...),(...)... will increase your performance
Also, I bet you are performing INSERT INTO(...) VALUES(...);
inserting multiple values at once - INSERT INTO(...) VALUES(...),(...),(...)... will increase your performance