在shortcut中,我可以使用快捷方式Ctrl + B
来美化MySQL查询。有没有办法缩小来自MySQL工作台的查询?
我的目标是减少使用量,优化响应速度。在运行下面的几次查询之后,对于精简的查询,它的性能更好,对于大数据表,它将有很大的不同。
最小化(持续时间:第一次尝试: 0.076秒,第二次尝试: 0.082秒,第三次尝试: 0.071秒)
SELECT (SELECT SUM(value) FROM keluar_masuk WHERE income_cost = 'income' AND currency = 'MYR') + ((SELECT SUM(value) FROM keluar_masuk WHERE income_cost = 'income' AND currency = 'USD') * (SELECT value FROM site_data WHERE what = 'usd_to_myr')) as income, (SELECT SUM(value) FROM keluar_masuk WHERE income_cost = 'cost' AND currency = 'MYR') + ((SELECT SUM(value) FROM keluar_masuk WHERE income_cost = 'cost' AND currency = 'USD') * (SELECT value FROM site_data WHERE what = 'usd_to_myr')) as cost
美化(时长:第一次尝试: 0.146秒,第二次尝试: 0.113秒,第三次尝试: 0.125秒)
SELECT
(SELECT
SUM(value)
FROM
keluar_masuk
WHERE
income_cost = 'income'
AND currency = 'MYR') + ((SELECT
SUM(value)
FROM
keluar_masuk
WHERE
income_cost = 'income'
AND currency = 'USD') * (SELECT
value
FROM
site_data
WHERE
what = 'usd_to_myr')) AS income,
(SELECT
SUM(value)
FROM
keluar_masuk
WHERE
income_cost = 'cost'
AND currency = 'MYR') + ((SELECT
SUM(value)
FROM
keluar_masuk
WHERE
income_cost = 'cost'
AND currency = 'USD') * (SELECT
value
FROM
site_data
WHERE
what = 'usd_to_myr')) AS cost
发布于 2018-06-10 18:46:21
答案很简单:不,MySQL工作台没有这样的特性。这真的不是人们经常想要的。
https://stackoverflow.com/questions/50778581
复制相似问题