Re: prepare insert statement outside while loop for speed

[McDarren]

in reply to prepare insert statement outside while loop for speed

$sth->execute($data[0],$data[1],$data[2], $data[3], $data[4],$data[5])

The above could be written a bit more succinctly as:

$sth->execute(@data[0 .. 5])

See Slices

Or, if you know that @data will always contain just six elements, then just simply:

$sth->execute(@data)

Hope this helps,
Darren