aboutsummaryrefslogtreecommitdiffhomepage
path: root/server/models
diff options
context:
space:
mode:
authorChocobozzz <me@florianbigard.com>2021-03-03 11:24:16 +0100
committerChocobozzz <me@florianbigard.com>2021-03-03 11:24:16 +0100
commit534556052ed4aab539325dccaa16c6dd2acecf73 (patch)
tree19e6c0a0729196e13eeab66398b6963e424b0181 /server/models
parent6c9c3b7b14411a854c8dcf8583d56b314e45a4ce (diff)
downloadPeerTube-534556052ed4aab539325dccaa16c6dd2acecf73.tar.gz
PeerTube-534556052ed4aab539325dccaa16c6dd2acecf73.tar.zst
PeerTube-534556052ed4aab539325dccaa16c6dd2acecf73.zip
Optimize views sort sql query
Diffstat (limited to 'server/models')
-rw-r--r--server/models/video/video.ts7
1 files changed, 6 insertions, 1 deletions
diff --git a/server/models/video/video.ts b/server/models/video/video.ts
index b4c7da655..b3543ddf2 100644
--- a/server/models/video/video.ts
+++ b/server/models/video/video.ts
@@ -426,7 +426,12 @@ export type AvailableForListIDsOptions = {
426 ] 426 ]
427 }, 427 },
428 { fields: [ 'duration' ] }, 428 { fields: [ 'duration' ] },
429 { fields: [ 'views' ] }, 429 {
430 fields: [
431 { name: 'views', order: 'DESC' },
432 { name: 'id', order: 'ASC' }
433 ]
434 },
430 { fields: [ 'channelId' ] }, 435 { fields: [ 'channelId' ] },
431 { 436 {
432 fields: [ 'originallyPublishedAt' ], 437 fields: [ 'originallyPublishedAt' ],