Re: Update more than 30,000 records row by row

[Yogesh Mahadnac]

Hello,

Many thanks for your reply.

Actually, the web application has been created using PHP as the scripting language, that's why I was thinking about using PHP for it, but, I would be open to your suggestions / recommendations.

Indeed, the data is quite sensitive, but I've created some kind of dummy data for you to understand how it is being stored. Here it is:

Info: ¦ ip: 10.100.100.100¦ lang: 2¦ Companyid: Array¦ title: Mrs.¦ name: Test, Test¦ phone: [phone] ¦ email: [e-mail]¦ company: ¦ language: UK / English¦ Class1: 1¦ dist: 10,2 km¦ dir: 2¦ Date1: 12.05.2011¦ Hour1H: 14¦ Minute1: 15¦ From1: City, Country¦ FromAd1: Airport¦ To1: City, Country¦ ToAd1: ¦ Passengers1: 3¦ lgn1: 1.1234567¦ lat1: 10.1234567¦ lgn2: 1.7654321¦ lat2: 10.543210¦ Date2: 17.05.2011¦ Hour2H: 12¦ Minute2: 45¦ From2: City, Country¦ FromAd2: ¦ To2: City, Country¦ ToAd2: Airport¦ Passengers2: 3¦ TextArea1: ¦ conditions: on



I was thinking about doing all the processing then passing everything to a Stored Procedure e.g.

call sp_UpdateRecord( param1, param2, param3....)

i.e. handing-over the update part to the MySQL db.

Your advices / recommendations are most welcome.

Thanks in advance.

Best regards,
Yogesh.