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) 2024 年1 月 1 日 21:54 5

NGINX 说请求的服务器时间是什么，这可能是网络问题吗？

话题		回复	浏览量
Have Data Explorer Show number of results? Feature	12	1678	2020 年11 月 3 日
How do I stop a runaway data explorer query? Bug	7	942	2022 年1 月 14 日
Discourse Data Explorer Plugin official , data-explorer , included-in-core	30	86289	2025 年10 月 22 日
Run Data Explorer queries with the Discourse API Integrations data-explorer , rest-api , how-to	14	14262	2025 年5 月 6 日
Missing query plans in Data Explorer Bug data-explorer	2	166	2025 年4 月 23 日

慢 Data Explorer 查询

相关话题