in reply to prepare insert statement outside while loop for speed
The above could be written a bit more succinctly as:$sth->execute($data[0],$data[1],$data[2], $data[3], $data[4],$data[5])
See Slices$sth->execute(@data[0 .. 5])
Or, if you know that @data will always contain just six elements, then just simply:
Hope this helps,$sth->execute(@data)
Darren
|
---|
In Section
Seekers of Perl Wisdom