diff options
| author | redmatrix <redmatrix@redmatrix.me> | 2015-06-10 16:59:04 -0700 |
|---|---|---|
| committer | redmatrix <redmatrix@redmatrix.me> | 2015-06-10 16:59:04 -0700 |
| commit | ca870dbf31d31455ab4f5e0f461c5af89e1573fa (patch) | |
| tree | 30bf8c1a116828dc0272b5677b717f7721809b3b /include/poller.php | |
| parent | 2128d5a2560383e0d3587087a7dd0aab217bc262 (diff) | |
| download | volse-hubzilla-ca870dbf31d31455ab4f5e0f461c5af89e1573fa.tar.gz volse-hubzilla-ca870dbf31d31455ab4f5e0f461c5af89e1573fa.tar.bz2 volse-hubzilla-ca870dbf31d31455ab4f5e0f461c5af89e1573fa.zip | |
more work on item table optimisation
Diffstat (limited to 'include/poller.php')
| -rw-r--r-- | include/poller.php | 6 |
1 files changed, 2 insertions, 4 deletions
diff --git a/include/poller.php b/include/poller.php index a175d59b5..09c642f6a 100644 --- a/include/poller.php +++ b/include/poller.php @@ -90,15 +90,13 @@ function poller_run($argv, $argc){ // (time travel posts). Restrict to items that have come of age in the last // couple of days to limit the query to something reasonable. - $r = q("select id from item where ( item_restrict & %d ) > 0 and created <= %s and created > '%s' ", - intval(ITEM_DELAYED_PUBLISH), + $r = q("select id from item where item_delayed = 1 and created <= %s and created > '%s' ", db_utcnow(), dbesc(datetime_convert('UTC','UTC','now - 2 days')) ); if($r) { foreach($r as $rr) { - $x = q("update item set item_restrict = ( item_restrict & ~%d ) where id = %d", - intval(ITEM_DELAYED_PUBLISH), + $x = q("update item set item_delayed = 0 where id = %d", intval($rr['id']) ); if($x) { |