Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

slow loading of frontpage #143

Open
emilravn opened this issue May 30, 2022 · 0 comments
Open

slow loading of frontpage #143

emilravn opened this issue May 30, 2022 · 0 comments
Labels
bug Something isn't working

Comments

@emilravn
Copy link
Contributor

func GetMessages(user string, page string) []map[string]interface{} {
var results []map[string]interface{}
offset, messagesPerPage := LimitMessages(page)
if user == "" {
database.DB.Table("messages").Limit(messagesPerPage).Order("created_at desc").Offset(offset).Find(&results)
} else {
database.DB.Table("messages").Where("author = ?", user).Limit(messagesPerPage).Order("created_at desc").Offset(offset).Find(&results)
}
return results
}
func LimitMessages(page string) (int, int) {
messagesPerPage := 50
p, err := strconv.Atoi(page)
if err != nil {
panic("Failed to parse page number")
}
offset := (p - 1) * messagesPerPage
return offset, messagesPerPage
}

Instead of loading all the messages and ordering, just get the first N messages without ordering them

@emilravn emilravn added the bug Something isn't working label May 30, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working
Projects
None yet
Development

No branches or pull requests

1 participant