diff options
author | Christopher Speller <crspeller@gmail.com> | 2018-09-10 06:20:01 -0700 |
---|---|---|
committer | Carlos Tadeu Panato Junior <ctadeu@gmail.com> | 2018-09-10 15:20:01 +0200 |
commit | a8d116b381ec9c28c5da5c8ee39a3699f568130d (patch) | |
tree | deac1ed66cbd21dd08f865e36feba230b433b2fd /store/sqlstore | |
parent | bb605a6b91073714f6b9a59b86c25c1b46bd2ba9 (diff) | |
download | chat-a8d116b381ec9c28c5da5c8ee39a3699f568130d.tar.gz chat-a8d116b381ec9c28c5da5c8ee39a3699f568130d.tar.bz2 chat-a8d116b381ec9c28c5da5c8ee39a3699f568130d.zip |
Speed up search results post selection. (#9380)
Diffstat (limited to 'store/sqlstore')
-rw-r--r-- | store/sqlstore/post_store.go | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/store/sqlstore/post_store.go b/store/sqlstore/post_store.go index 14a6039bc..9cf33888d 100644 --- a/store/sqlstore/post_store.go +++ b/store/sqlstore/post_store.go @@ -1156,7 +1156,7 @@ func (s *SqlPostStore) GetPostsByIds(postIds []string) store.StoreChannel { params[key] = postId } - query := `SELECT * FROM Posts WHERE Id in (` + keys.String() + `) and DeleteAt = 0 ORDER BY CreateAt DESC` + query := `SELECT * FROM Posts WHERE Id in (` + keys.String() + `) ORDER BY CreateAt DESC` var posts []*model.Post _, err := s.GetReplica().Select(&posts, query, params) |