in reply to Re^2: DBI: How to update 150K records efficiently
in thread DBI: How to update 150K records efficiently
My question is: can we get the same 'prepare' effects as moritz mentioned in his post, since 'prepare' is done before the while loop..:)
That is done automatically. DBIx::Simple recognises that the query is the same each time, and re-uses the old statement handle that represents the already compiled query.
In Section
Seekers of Perl Wisdom