search for: selectsql

Displaying 2 results from an estimated 2 matches for "selectsql".

Did you mean: selects
2004 Jun 22
0
Perl Script for pulling information from a mysql database
...ation Section ### use POSIX qw(strftime); use DBI; # Database connect and define subroutines $dsn = "DBI:mysql:database=$mysql_db;hostname=$mysql_host"; $dbh = DBI->connect($dsn, $mysql_user, $mysql_pass) || die "Can''t connect to database: " . DBI->errstr; sub SelectSQL { my($sql) = @_; my @MATCHES, $hash; $sth = $dbh->prepare("$sql"); $sth->execute(); while ($hash = $sth->fetchrow_hashref) { push @MATCHES, $hash; } return @MATCHES; } sub SelectSingleSQL { my($sql) = @_; my($gotit, $return, $hash); $sth = $dbh->pr...
2004 Jul 02
24
TC Hashing Filters
Hey all, I had asked a question a little while ago about CPU usage being outrageous while using tc and a cbq qdisc. Ed was very kind and offered a few suggestions. One of these was to look at hashing. So after pounding away at it for about a week, I have a general understanding of how it works and have tried to implement it. Unfortunately, and quite obviously since I''m posting here, it