Yes, that is what prepares are for. Ilya
-----Original Message----- From: John Day [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 18, 2002 9:49 AM To: [EMAIL PROTECTED] Subject: Nested prepares 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
