I would like to rewrite an application using DBI, DBD and mySQL so that I can prepare a several statements once using placeholders and then execute them within a loop without re-preparing them.
Basically for each of about 2,000 clients I have to read up to 750,000 records, modify each one and write it back. I would like to improve efficiency by not having to prepare the statement each time (as the version I am rewriting does). Will this work? I am using latest DBI, DBD, mySQL on Linux with Perl 5.6 John Day Words & Images
