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

2 files changed, 39 insertions, 37 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)
 }
diff --git a/modules/lists/lists.go b/modules/lists/lists.go
index 3febdba..836f6af 100644
--- a/modules/lists/lists.go
+++ b/modules/lists/lists.go
@@ -180,10 +180,6 @@ func ListsToCards(lists []*List) []frontend.Card {
         var cards []frontend.Card
 
         for _, list := range lists {
-                s := "s"
-                if len(list.Grils) == 1 {
-                        s = ""
-                }
                 cards = append(cards, frontend.Card{
                         Title:       list.Name,
                         Description: list.Description,
@@ -194,7 +190,7 @@ func ListsToCards(lists []*List) []frontend.Card {
                                         Link: fmt.Sprintf("/list/%d", list.ID),
                                 },
                                 frontend.Action{
-                                        Name:     fmt.Sprintf(`<span class="chip">%d gril%s</span>`, len(list.Grils), s),
+                                        Name:     fmt.Sprintf(`<span class="chip">von <a class="purple-text text-lighten-2" style="margin-right: 0px" href="/user/%d/%s">%s</a></span>`, list.Owner.ID, list.Owner.GetName(), list.Owner.GetName()),
                                         Link:     "#",
                                         Disabled: true,
                                 },
@@ -214,11 +210,11 @@ func (m *Module) ProvideDashboardData(user *charakterin.User) []grilist.Dashboar
                 log.Println(err)
                 return categories
         }
-        for _, list := range lists {
-                if err := m.getListGrils(list); err != nil {
-                        log.Println(err)
-                }
-        }
+        //for _, list := range lists {
+        //if err := m.getListGrils(list); err != nil {
+        //      log.Println(err)
+        //}
+        //}
 
         categories = append(categories, grilist.DashboardCategory{
                 Title: "Neueste Listen",
@@ -230,7 +226,7 @@ func (m *Module) ProvideDashboardData(user *charakterin.User) []grilist.Dashboar
         }
 
         // Listen des Benutzers
-        lists = m.GetUserLists(user, true)
+        lists = m.GetUserLists(user, false)
 
         categories = append(categories, grilist.DashboardCategory{
                 Title: "Meine Listen",