Page 1 of 1

MYSQL Execution Issue

Posted: Fri Jul 24, 2009 12:35 am
by habib009pk
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

Re: MYSQL Execution Issue

Posted: Fri Jul 24, 2009 1:10 am
by Darhazer
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