This coding may not be so difficult, but not easy for me.

The issue will be converting:

   insert into foo ( field, fields ) values ( ... );

into

   insert into foo ( field, fields ) values ( ?, ?, ? )

After that you can use prepare_cached on the
sql to get a re-usable statement handle and
reduce the preparation.

If the values being inserted are not too
convoluted (e.g., don't involve newlines,
commas, or quotes as data) then a few
splits and regexen should allow you to
standardize the queries and use prepare_cached.

I don't think "Memoize.pm" can be used, :)

No, because you don't want to short-circut the
acutal call.




--
Steven Lembark                                       85-09 90th Street
Workhorse Computing                                Woodhaven, NY 11421
[EMAIL PROTECTED]                                     1 888 359 3508

Reply via email to