diff options
author | Chocobozzz <me@florianbigard.com> | 2021-03-03 11:24:16 +0100 |
---|---|---|
committer | Chocobozzz <me@florianbigard.com> | 2021-03-03 11:24:16 +0100 |
commit | 534556052ed4aab539325dccaa16c6dd2acecf73 (patch) | |
tree | 19e6c0a0729196e13eeab66398b6963e424b0181 /server/models | |
parent | 6c9c3b7b14411a854c8dcf8583d56b314e45a4ce (diff) | |
download | PeerTube-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.ts | 7 |
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' ], |