Clear questions and runnable code get the best and fastest answer |
|
PerlMonks |
Re: Improving SQL speedby gmargo (Hermit) |
on Nov 01, 2009 at 16:40 UTC ( [id://804358]=note: print w/replies, xml ) | Need Help?? |
One alternative is to process all the mp3 files, and then write all the data simultaneously in one call to execute_array, instead of one call to execute for each mp3 file. It's more work to set up (must accumulate all data in separate arrays and use bind_param_array) but for a large number of entries it will probably be faster.
In Section
Seekers of Perl Wisdom
|
|