perl DBI performance of a massive amount of inserts

[travs69]

I have been tweaking some code I have to minimize the time in which it runs.. I am currently doing about 2200 inserts in 53 seconds and I don't know if I am using the best DBI method to do it. I am currently using "do" but was wondering if preparing the statement once and then executing it would help out.
my query looks like this (real variable names taken out for readability)

$query2 = "insert into trapd_statistics (alarm_time, source, trapd_server, real_alarm, logonly_alarm, unknown_alarm) values ('$var1', '$var2', '$var3', '$var4', '$var5', '$var6')";
$dbh->do($query2)

For the 2253 entries there are 807 distinct alarm_time, 30 distinct source, 1 distinct trapd_server, and the alarms are pretty varied.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Travis - Those who say it cannot be done are usually interrupted by someone else doing it; Give the wrong symptoms, get the wrong solutions;

 

[travs69]

Ignore ignore.. for some reason I didn't realize I could do all the inserts in one big statement.. The insert statement now takes 1 sec to insert all 2200 rows.



~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Travis - Those who say it cannot be done are usually interrupted by someone else doing it; Give the wrong symptoms, get the wrong solutions;