Actions
Enhancement（機能追加・改善） #1356
open
スロークエリ：message の速度改善
Start date:
2010-07-14
Due date:
% Done:
0%
Estimated time:
Description
平均レスポンス時間: 1.652
- SELECT COUNT AS num_results FROM (SELECT m.id FROM message_send_list m LEFT JOIN message m2 ON m.message_id = m2.id WHERE m.member_id = 'S' AND m.is_deleted = 'S' AND m.is_read = 'S' AND m2.is_send = 'S' GROUP BY m.id) dctrn_count_query
→ https://trac.openpne.jp/svn/OpenPNE3/plugins/opMessagePlugin/branches/tuning_slowquery_3_6beta1 のコミット r13565 のマージをお願いします。
Updated by
Actions