my $sth = $dbh->prepare("SELECT * FROM big_table LIMIT ?");
$sth->bind_param(1, $value, SQL_INTEGER);
$sth->execute(10);