versuchen, die performance zu erhöhen indem wir nicht grils_flattened für updated_at verwenden, weil das view extrem langsam ist.

1 files changed, 15 insertions, 3 deletions

diff --git a/modules/grils/grils.go b/modules/grils/grils.go
index a38f41f..8ec7bcb 100644
--- a/modules/grils/grils.go
+++ b/modules/grils/grils.go
@@ -97,17 +97,30 @@ func (m *GrilsModule) GetListsOfGril(gril *Gril) error {
 func (m *GrilsModule) ProvideDashboardData(user *charakterin.User) []grilist.DashboardCategory {
         var categories []grilist.DashboardCategory
 
-        grils, err := m.getGrils(`1 = 1 ORDER BY updated_at DESC LIMIT 5`)
+        rows, err := m.g.DB.Query(`SELECT id FROM grilist.grils ORDER BY updated_at DESC LIMIT 5`)
         if err != nil {
                 log.Println(err)
                 return categories
         }
+        defer rows.Close()
 
         cat := grilist.DashboardCategory{
                 Title: "Neue Grils",
         }
 
-        for _, gril := range grils {
+        for rows.Next() {
+                var id int
+                if err := rows.Scan(&id); err != nil {
+                        log.Println(err)
+                        continue
+                }
+
+                gril, err := m.FromID(id)
+                if err != nil {
+                        log.Println(err)
+                        continue
+                }
+
                 cat.Cards = append(cat.Cards, frontend.Card{
                         Title:       gril.RomajiName,
                         Description: gril.KanjiName,
@@ -120,7 +133,6 @@ func (m *GrilsModule) ProvideDashboardData(user *charakterin.User) []grilist.Das
                         },
                 })
         }
-
         categories = append(categories, cat)
         return categories
 }