nning after about 30 hours. It looks like 'order by hdate
desc limit 1' is a LOT SLOWER than 'order by hdate limit 1' for some
reason. Must be internal MySQL stuff...
Thanks,
Lincoln
From: Marcello <[EMAIL PROTECTED]>
Date: October 5, 2005 11:35:16 AM EDT
To: beg
rutledge.50 ha scritto:
Hi, thanks Marcello :)
I finally figured it out by painfully following 10 sets of data through
the process.
First, this was causing two problems:
#now cycle through result set in next query
foreach $myhsid (@hsid)
{
$myhport = pop(@hport);
$my
linc ha scritto:
Howdy,
I'm having some serious trouble. I'm running a query and getting the
data, but having problems using that data in the next query. Thus:
#first query
$sth = $dbh->prepare
( "select distinct hmac, hport, hsid from netdata_history" );
$sth->execute( );
$sth->bind
