diff options
| author | Mario <mario@mariovavti.com> | 2025-01-30 12:10:45 +0000 |
|---|---|---|
| committer | Mario <mario@mariovavti.com> | 2025-01-30 12:10:45 +0000 |
| commit | 2782b6d724f2770d96a20d7f33d2cb9480d3bcf3 (patch) | |
| tree | 471fcd478a51f0942ea4d78c6ed744e99bf6090f | |
| parent | 324b2818133eb3f72a18c836724a3419f204671f (diff) | |
| download | volse-hubzilla-2782b6d724f2770d96a20d7f33d2cb9480d3bcf3.tar.gz volse-hubzilla-2782b6d724f2770d96a20d7f33d2cb9480d3bcf3.tar.bz2 volse-hubzilla-2782b6d724f2770d96a20d7f33d2cb9480d3bcf3.zip | |
possible sql performance improvements
(cherry picked from commit dc076a4c003124719c15cd681bf0684710d0b93d)
Co-authored-by: Mario Vavti <mario@mariovavti.com>
| -rw-r--r-- | Zotlabs/Daemon/Importdoc.php | 7 | ||||
| -rw-r--r-- | Zotlabs/Module/Sse_bs.php | 10 |
2 files changed, 10 insertions, 7 deletions
diff --git a/Zotlabs/Daemon/Importdoc.php b/Zotlabs/Daemon/Importdoc.php index 46f96098f..de571848e 100644 --- a/Zotlabs/Daemon/Importdoc.php +++ b/Zotlabs/Daemon/Importdoc.php @@ -11,15 +11,18 @@ class Importdoc { self::update_docs_dir('doc/*'); + $sys = get_sys_channel(); + // remove old files that weren't updated (indicates they were most likely deleted). - $i = q("select id, uid from item where item_type = 5 and edited < %s - INTERVAL %s", + $i = q("select id from item where uid = %d and item_type = 5 and edited < %s - INTERVAL %s", + intval($sys['channel_id']), db_utcnow(), db_quoteinterval('14 DAY') ); if ($i) { foreach ($i as $iv) { - drop_item($iv['id'], uid: $iv['uid']); + drop_item($iv['id'], uid: $sys['channel_id']); } } diff --git a/Zotlabs/Module/Sse_bs.php b/Zotlabs/Module/Sse_bs.php index d214ba28f..5292abfaa 100644 --- a/Zotlabs/Module/Sse_bs.php +++ b/Zotlabs/Module/Sse_bs.php @@ -207,7 +207,7 @@ class Sse_bs extends Controller { $item_normal $sql_extra $sql_extra2 - ORDER BY created DESC LIMIT $limit OFFSET $offset", + ORDER BY created DESC, received DESC LIMIT $limit OFFSET $offset", intval(self::$uid), dbescdate($_SESSION['sse_loadtime']), dbesc(self::$ob_hash) @@ -290,7 +290,7 @@ class Sse_bs extends Controller { $item_normal $sql_extra $sql_extra2 - ORDER BY created DESC LIMIT $limit OFFSET $offset", + ORDER BY created DESC, received DESC LIMIT $limit OFFSET $offset", intval(self::$uid), dbescdate($_SESSION['sse_loadtime']), dbesc(self::$ob_hash) @@ -373,7 +373,7 @@ class Sse_bs extends Controller { $item_normal $sql_extra $sql_extra2 - ORDER BY created DESC LIMIT $limit OFFSET $offset", + ORDER BY created DESC, received DESC LIMIT $limit OFFSET $offset", intval(self::$uid), dbescdate($_SESSION['sse_loadtime']), dbesc(self::$ob_hash) @@ -481,7 +481,7 @@ class Sse_bs extends Controller { $sql_extra $sql_extra2 $sql_extra3 - ORDER BY created DESC LIMIT $limit OFFSET $offset", + ORDER BY created DESC, received DESC LIMIT $limit OFFSET $offset", dbescdate($_SESSION['sse_loadtime']), dbesc(self::$ob_hash), dbescdate($_SESSION['last_login_date'] ?? $_SESSION['static_loadtime']) @@ -679,7 +679,7 @@ class Sse_bs extends Controller { AND author_xchan != '%s' AND item_unseen = 1 $item_normal - ORDER BY created DESC", + ORDER BY created DESC, received DESC", dbesc(ACTIVITY_POST), intval(self::$uid), dbesc(self::$ob_hash) |