Permalink
Browse files

INTERVAL 0 DAY is not helping, in fact it's adding a filesort on

stories (ick).  Let's try it without.
  • Loading branch information...
1 parent cc226ca commit 72160d11a6023322f850fc2e0f2bcb2ae2c33ca8 @jamiemccarthy jamiemccarthy committed Jan 31, 2003
Showing with 2 additions and 2 deletions.
  1. +2 −2 Slash/DB/MySQL/MySQL.pm
View
@@ -4524,8 +4524,8 @@ sub getStoriesEssentials {
my $columns;
$columns = 'sid, section, title, time, commentcount, hitparade, tid';
- #my $where = "time < NOW() ";
- my $where = " time + INTERVAL 0 DAY<NOW() ";
+ my $where = "time < NOW() ";
+ #my $where = " time + INTERVAL 0 DAY<NOW() ";
# Added this to narrow the query a bit more, I need
# see about the impact on this -Brian
$where .= "AND writestatus != 'delete' ";

0 comments on commit 72160d1

Please sign in to comment.