perlquestion
Herkum
<p>I am saving a bunch of objects to database, and right now I am saving each object individually with its own INSERT statement. So 1000 objects, 1000 insert dbi calls.</p>
<p>I was thinking I could get a performance boost if I made it one large SQL statement and do a batch insert like below</p>
<code>
INSERT INTO table (description) VALUES (?),(?),(?)
etc...
</code>
<p>However, before I go down this road I was wondering if I would really get any performance benefits. Statement handles are already prepared, so that is not an issue, but if I insert 1000 objects, that means I am binding about 40,000 variables to this INSERT statement. I am wondering would that really bring any performance improvements or would I be better served by interpolating the values into the SQL?</p>
<p>Any have advice on the subject?</p>