MYSQL Execution Issue

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
habib009pk
Forum Commoner
Posts: 43
Joined: Sun Jul 05, 2009 11:28 pm

MYSQL Execution Issue

Post 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
User avatar
Darhazer
DevNet Resident
Posts: 1011
Joined: Thu May 14, 2009 3:00 pm
Location: HellCity, Bulgaria

Re: MYSQL Execution Issue

Post 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
Post Reply