On Thu, 27 Sep 2007, Henrik Krohns wrote: > mysql> SELECT count(*) FROM bayes_token WHERE id = '1' AND (1190870335 - > atime) > 345600; > +----------+ > | count(*) | > +----------+ > | 1710591 | > +----------+ > 1 row in set (5.69 sec) > > mysql> SELECT count(*) FROM bayes_token WHERE id = '1' AND atime < 1190870335 > - 345600; > +----------+ > | count(*) | > +----------+ > | 1710582 | > +----------+ > 1 row in set (5.72 sec)
>From those performance numbers it looks like there is not an index on the atime column... -- John Hardin KA7OHZ http://www.impsec.org/~jhardin/ [EMAIL PROTECTED] FALaholic #11174 pgpk -a [EMAIL PROTECTED] key: 0xB8732E79 -- 2D8C 34F4 6411 F507 136C AF76 D822 E6E6 B873 2E79 ----------------------------------------------------------------------- Pelley: Will you pledge not to test a nuclear weapon? Ahmadeinejad: CIA! Secret prison in Europe! Abu Ghraib! -- Mahmoud Ahmadeinejad clumsily dodges a question (60 minutes interview, 9/20/2007) ----------------------------------------------------------------------- 241 days until the Mars Phoenix lander arrives at Mars
