Changes between Initial Version and Version 1 of Ticket #11206
- Timestamp:
- Jun 17, 2013, 9:41:16 AM (11 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
Ticket #11206 – Description
initial v1 15 15 16 16 After profiling the query: Copying to tmp table cost 99.355% percentage of whole time. 17 If ''((COALESCE(t.summary,'')='querystr'))'' changed to ''t.summary = "querystr"'',17 If `((COALESCE(t.summary,'')='querystr'))` changed to `t.summary = "querystr"`, 18 18 this copy action will not take that much time. 19 19 And if count only 0, problem still happens, if not count, problem not exists, maybe we can directly select the result with count. 20 Or break this query into ''t.summary = '' or t.summary is null''if query string is empty.20 Or break this query into `t.summary = '' or t.summary is null` if query string is empty. 21 21 22 22 Another problem is 'priority' column are regarded as required fields even I deselect priority column, thus join will be need every query.