or download this
my $query = $self->{dbh}->prepare("select * from $database.$self->{hit
+_table} where time between ? and ? order by visit_id, time", {'mysql_
+use_result' => $self->{optimize}});
$query->execute($start_time + 0, $end_time + 0);
...
{
# Do calculation
}