Mysql視圖一共500條資料，打開電腦后，第一次打開總是加載188多秒，正常的話應該是加載不到1秒，什么原因啊
uj5u.com熱心網友回復：
有人嗎？給回復下uj5u.com熱心網友回復：
本身就不快吧，第一次加載慢，之后都是讀快取，所以快。最好能把視圖內容發來看一下。
uj5u.com熱心網友回復：
SELECT`meters`.`儀表檔案編號` AS `儀表檔案編號`,
`dfelecmeterparameter_single`.`設備線號` AS `設備線號`,
`meters`.`變比系數` AS `變比系數`,
`meters`.`特表標識` AS `特表標識`,
`meters`.`安裝位置` AS `安裝位置`,
`dfelecmeterparameter_single`.`售電次數` AS `售電次數`,
`dfelecmeterparameter_single`.`售電狀態` AS `售電狀態`,
`rooms`.`住房檔案編號` AS `住房檔案編號`,
`rooms`.`住房名稱` AS `住房名稱`,
(
CASE
WHEN ( substr( `dfmetertype`.`功能描述`, 14, 1 ) = '1' ) THEN
14
WHEN ( substr( `dfmetertype`.`功能描述`, 3, 1 ) = '1' ) THEN
3
END
) AS `注銷指令`,
(
CASE
WHEN ( substr( `dfmetertype`.`功能描述`, 29, 1 ) = '1' ) THEN
29
WHEN ( substr( `dfmetertype`.`功能描述`, 30, 1 ) = '1' ) THEN
30
WHEN ( substr( `dfmetertype`.`功能描述`, 22, 1 ) = '1' ) THEN
22
END
) AS `抄表指令`,
`rooms`.`建檔時間` AS `建檔時間`,
`meters`.`儀表型別` AS `儀表型別`,
`meters`.`儀表標注` AS `儀表標注`,
`meters`.`卡編號` AS `卡編號`,
`users`.`住戶姓名` AS `住戶姓名`,
`users`.`住戶狀態` AS `住戶狀態`,
`meters`.`是否開戶` AS `是否開戶`,
`meters`.`開戶時間` AS `開戶時間`,
`meters`.`型別編號` AS `型別編號`,
`dfelecmeterparameter_wholemeter`.`設備型別` AS `設備型別`,
`meters`.`卡號` AS `卡號`,
`rooms`.`電話號碼` AS `電話號碼`,
`meters`.`單價編碼` AS `單價編碼`,
`price`.`預付費單價` AS `預付費單價`,
`users`.`住戶檔案編號` AS `住戶檔案編號`,
`meters`.`儀表編號` AS `儀表編號`,
`dfelecmeterparameter_single`.`出廠編號` AS `出廠編號`,
`users`.`用戶名` AS `用戶名`,
`users`.`密碼` AS `密碼`,
`users`.`身份證號` AS `身份證號`,
`dfelecmeterparameter_single`.`是否推送` AS `是否推送`,
`dfelecmeterparameter_wholemeter`.`通訊地址` AS `通訊地址`,
`dfelecmeterparameter_wholemeter`.`協議型別` AS `協議型別`,
`dfelecmeterparameter_single`.`單價` AS `單價`,
`dfelecmeterparameter_single`.`單價改變` AS `單價改變`,
`meters`.`軟體預付費` AS `軟體預付費`,
`meters`.`總購電量` AS `總購電量`,
`rooms`.`xiaoqu_id` AS `xiaoqu_id`,
`rooms`.`loudong_id` AS `loudong_id`,
`rooms`.`room_id` AS `room_id`,
`meters`.`是否卡開戶` AS `是否卡開戶`,
`price`.`服務費` AS `服務費`,
`price`.`水電費` AS `水電費`
FROM
(
(
(
(
(
( ( `rooms` JOIN `meters` ) JOIN `price` ON ( ( `meters`.`單價編碼` = `price`.`單價編碼` ) ) )
JOIN `dfelecmeterparameter_single` ON ( ( `meters`.`儀表檔案編號` = `dfelecmeterparameter_single`.`儀表檔案編號` ) )
)
JOIN `dfelecmeterparameter_wholemeter` ON ( ( `dfelecmeterparameter_single`.`出廠編號` = `dfelecmeterparameter_wholemeter`.`出廠編號` ) )
)
JOIN `dfmetertype` ON ( ( `dfelecmeterparameter_wholemeter`.`設備型別` = `dfmetertype`.`型別編號` ) )
)
JOIN `roommeter` ON ( ( ( `meters`.`儀表檔案編號` = `roommeter`.`儀表檔案編號` ) AND ( `rooms`.`住房檔案編號` = `roommeter`.`住房檔案編號` ) ) )
)
JOIN `users` ON ( ( `rooms`.`住房檔案編號` = `users`.`住房編號` ) )
)
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/69873.html
標籤：MySQL
上一篇：SQL查詢