diff options
author | JoramWilander <jwawilander@gmail.com> | 2015-08-27 16:25:05 -0400 |
---|---|---|
committer | JoramWilander <jwawilander@gmail.com> | 2015-08-27 16:25:05 -0400 |
commit | f35948555731100292c11c230ce51990afc0973d (patch) | |
tree | 7c9e7b6a6827ce7434d060ddc639c455870f3246 | |
parent | 773e3fa377afb449ca18a3b8a93a27eb321cbc63 (diff) | |
download | chat-f35948555731100292c11c230ce51990afc0973d.tar.gz chat-f35948555731100292c11c230ce51990afc0973d.tar.bz2 chat-f35948555731100292c11c230ce51990afc0973d.zip |
Change GetPostsSince limit to 1000 and only add updated posts to post list order.
-rw-r--r-- | store/sql_post_store.go | 8 |
1 files changed, 5 insertions, 3 deletions
diff --git a/store/sql_post_store.go b/store/sql_post_store.go index 4ea28507b..f083a07c9 100644 --- a/store/sql_post_store.go +++ b/store/sql_post_store.go @@ -291,7 +291,7 @@ func (s SqlPostStore) GetPostsSince(channelId string, time int64) StoreChannel { WHERE (UpdateAt > :Time AND ChannelId = :ChannelId) - LIMIT 100) + LIMIT 1000) UNION (SELECT * @@ -307,7 +307,7 @@ func (s SqlPostStore) GetPostsSince(channelId string, time int64) StoreChannel { WHERE UpdateAt > :Time AND ChannelId = :ChannelId - LIMIT 100) temp_tab)) + LIMIT 1000) temp_tab)) ORDER BY CreateAt DESC`, map[string]interface{}{"ChannelId": channelId, "Time": time}) @@ -319,7 +319,9 @@ func (s SqlPostStore) GetPostsSince(channelId string, time int64) StoreChannel { for _, p := range posts { list.AddPost(p) - list.AddOrder(p.Id) + if p.UpdateAt > time { + list.AddOrder(p.Id) + } } result.Data = list |