I created some Data Explorer queries. If I execute them in the admin backend, the GUI shows me a very quick execution time for the DB query itself, e.g. “Query completed in 7.9 ms.” The network log of my browser shows that e.g. https://example.com/admin/plugins/explorer/queries/1/run was accessed…

From the information you provided, I’d say that those are simple queries (fast to execute in the RDBMS), that return many rows (slow to de/serialize in the backend and transfer). If the current performance is blocking your use case, there are many different solutions you can explore: Lowering ro…

[이미지] n1bff: DB query itself, e.g. “Query completed in 7.9 ms.” We have magical lookups for certain column names (user_id, post_id, etc) alias them to something else like post_id1 etc..

Thanks guys! [이미지] Falco: Lowering row counts per page, so each page is faster. It is the same if I have just one single row as result of a query. E.g. a query that returns a single integer, ran in the Data Explorer panel in the admin backend it takes 9 ms, ran from the outside against the D…

[이미지] n1bff: My query uses them for JOINs but not in the result set. The SELECT only has one column and that is a newly calculated one with a arbitrary name. What does NGINX say the server time is for the request, could this be a network issue?

Assuming that those are the floating point numbers 3 places right of the HTTP status code (e.g. ... 200 642 "-" **0.107 0.108** "system" ..., highlighted with stars by me) they are about 10 times the duration of the query time reported in the backend and pretty much exactly half the time it takes to…

느린 Data Explorer 쿼리

커뮤니티 구축 데이터 및 보고

sam (Sam Saffron) 1월 1, 2024, 9:54오후 5

NGINX가 요청에 대해 서버 시간을 어떻게 보고 있나요? 이는 네트워크 문제일 수 있을까요?

글		댓글	조회수
Have Data Explorer Show number of results? Feature	12	1678	11월 3, 2020
How do I stop a runaway data explorer query? Bug	7	941	1월 14, 2022
Discourse Data Explorer Plugin official , data-explorer , included-in-core	30	86276	10월 22, 2025
Run Data Explorer queries with the Discourse API Integrations data-explorer , rest-api , how-to	14	14260	5월 6, 2025
Missing query plans in Data Explorer Bug data-explorer	2	166	4월 23, 2025

느린 Data Explorer 쿼리

Related topics