thedevdojo/voyager

"select * from `data_types`" query in every request.

Open

#3,396 创建于 2018年7月12日

在 GitHub 查看
 (14 评论) (0 反应) (0 负责人)PHP (11,817 star) (2,652 fork)batch import
help wanted

描述

I have a site with high traffic. I used voyager to manage contents. but I noticed that its running a single query more than millions of times. the query is select * from data_types

I only want to load voyager when the url only have /admin, otherwise not.

I've tried by removing TCG\Voyager\VoyagerServiceProvider::class from service provider but without that the voyager is still running.

Please suggest how can I solve the issue.

贡献者指南

技术栈
laravelsql
领域
backendperformance
议题类型
performance
难度面向新贡献者的预计实现难度，1 表示很小改动，5 表示专家级工作。
3
预计时间有经验贡献者完成调查、实现、测试并准备 pull request 的粗略时间范围。
1-3 hours
活动状态议题当前的可参与程度：新鲜、活跃、陈旧、阻塞或等待维护者输入。
stale
清晰度议题是否清楚说明期望改动、验收标准和下一步。
mostly clear
前置要求
Understanding Laravel service providersBasic SQL knowledge
新手友好度1-100 的估计分数，表示该议题对首次贡献者的友好程度。
25
研究方向
Investigate the Voyager service provider registration and the data types query. Look at VoyagerServiceProvider to see how it bootstraps the admin panel. Also check if there is middleware that loads Voyager on all routes. Consider adding a condition in the service provider's register() method to only load when the request URI starts with /admin. Review the voyager.php config file for any default settings. Check comments in the issue for any suggested solutions.