temporaer laufzeiten der module (dashboard data) loggen, views angepasst, dashboard in goroutines aufgeteilt, weniger daten fuers listendashboard holen (reduktion von 6s -> 300ms insgesamt)

1 files changed, 32 insertions, 26 deletions

diff --git a/modules/grils/grils.go b/modules/grils/grils.go
index e6aaa11..fe947bc 100644
--- a/modules/grils/grils.go
+++ b/modules/grils/grils.go
@@ -7,6 +7,7 @@ import (
         "regexp"
         "strconv"
         "strings"
+        "time"
 
         "fagott.pw/charakterin"
         "fagott.pw/grilist/frontend"
@@ -96,12 +97,14 @@ func (m *GrilsModule) GetListsOfGril(gril *Gril) error {
 func (m *GrilsModule) ProvideDashboardData(user *charakterin.User) []grilist.DashboardCategory {
         var categories []grilist.DashboardCategory
 
+        t1 := time.Now()
         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()
+        log.Printf("get_newest_grils: %dms", time.Since(t1).Nanoseconds()/1000000)
 
         cat := grilist.DashboardCategory{
                 Title: "Neue Grils",
@@ -114,11 +117,13 @@ func (m *GrilsModule) ProvideDashboardData(user *charakterin.User) []grilist.Das
                         continue
                 }
 
+                t2 := time.Now()
                 gril, err := m.FromID(id)
                 if err != nil {
                         log.Println(err)
                         continue
                 }
+                log.Printf("get_gril_from_id_in_newest_grils: %dms", time.Since(t2).Nanoseconds()/1000000)
 
                 cat.Cards = append(cat.Cards, frontend.Card{
                         Title:       gril.RomajiName,
@@ -133,6 +138,7 @@ func (m *GrilsModule) ProvideDashboardData(user *charakterin.User) []grilist.Das
                 })
         }
         categories = append(categories, cat)
+        log.Printf("get_newest_grils_overall: %dms", time.Since(t1).Nanoseconds()/1000000)
         return categories
 }
 
@@ -195,36 +201,36 @@ func (m *GrilsModule) viewGril(w http.ResponseWriter, r *http.Request, p httprou
         data := m.g.Renderer.DefaultData()
         data["user"] = user
         data["gril"] = gril
-    
-    // ähnliche grils holen
-    rows, err := m.g.DB.Query(`SELECT gril_id FROM (
+
+        // ähnliche grils holen
+        rows, err := m.g.DB.Query(`SELECT gril_id FROM (
         SELECT DISTINCT gril_id FROM gril_appearance WHERE appearance_id IN (SELECT appearance_id FROM gril_appearance WHERE gril_id = $1)
         ) as t
     ORDER BY RANDOM()
     LIMIT 4;`, id)
-    if err != nil {
-        log.Println("could not get similar grils:", err)
-        http.Error(w, "500", http.StatusInternalServerError)
-        return
-    }
-    
-    defer rows.Close()
-    var similar []*Gril
-    for rows.Next() {
-        var id int
-        if err := rows.Scan(&id); err != nil {
-            log.Println("error scanning for similar gril:", err)
-            continue
-        }
-        
-        g, err := m.FromID(id)
-        if err != nil {
-            log.Println("invalid similar gril:", err)
-            continue
-        }
-        similar = append(similar, g)
-    }
-    data["SimilarGrils"] = similar
+        if err != nil {
+                log.Println("could not get similar grils:", err)
+                http.Error(w, "500", http.StatusInternalServerError)
+                return
+        }
+
+        defer rows.Close()
+        var similar []*Gril
+        for rows.Next() {
+                var id int
+                if err := rows.Scan(&id); err != nil {
+                        log.Println("error scanning for similar gril:", err)
+                        continue
+                }
+
+                g, err := m.FromID(id)
+                if err != nil {
+                        log.Println("invalid similar gril:", err)
+                        continue
+                }
+                similar = append(similar, g)
+        }
+        data["SimilarGrils"] = similar
 
         m.g.Renderer.RenderPage("gril", w, data)
 }