OH-SHOWN / ohshown-frontend

Frontend of OH!SHOWN 野生動物出沒痕跡通報系統 ohshown.site . Built with Vue.js. For backend please checkout https://github.com/OH-SHOWN/ohshown-backend
http://ohshown.site:8080/
4 stars 7 forks source link

Improve the performance of "follow up for user" #67

Open tai271828 opened 2 years ago

tai271828 commented 2 years ago

Describe the solution you'd like Inspired by swind who is a contributor of Disfactory. Quote from the slack message: https://g0v-tw.slack.com/archives/CNA60GZJM/p1648205822270069

swind:
我發現慢還有另外一個原因,我之前在實做 follow up for user ( 要顯示給使用者看的 follow up ) 做的方法不好。
導致每多一個工廠就會多一次 SQL query,這個我修正掉了。
目前已經更新到 staging,不過預設座標那邊顯示還是蠻慢的
那個區域工廠太密集,顯示還是需要 5s 左右