Select Code to Download

# either
my $dbh = DBI->connect("dbi:mysql:dbname;mysql_server_prepare=1",
...

# or 
$dbh->{ mysql_server_prepare } = 1;

export MYSQL_SERVER_PREPARE=1

my $query = qq{SELECT col1, col2, col3 FROM mytable LIMIT ? , ?};
my $sth = $dbh->prepare($query);
...
    $sth->execute($page_no, $lines);
    # do something with the page.
}

$dbh1->{ mysql_server_prepare } = 0;  # emulated prepared statement
$dbh2->{ mysql_server_prepare } = 1;  # real prepared statement
...
print "prepared\n", $dbh2->{Profile}->format;
$dbh1->{Profile} =0;
$dbh2->{Profile} =0;