Edgewall Software

Changes between Initial Version and Version 1 of Ticket #11206


Ignore:
Timestamp:
Jun 17, 2013, 9:41:16 AM (7 years ago)
Author:
Jun Omae
Comment:

Legend:

Unmodified
Added
Removed
Modified
  • Ticket #11206 – Description

    initial v1  
    1515
    1616After 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"'',
     17If `((COALESCE(t.summary,'')='querystr'))` changed to `t.summary = "querystr"`,
    1818this copy action will not take that much time.
    1919And 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.
     20Or break this query into `t.summary = '' or t.summary is null` if query string is empty.
    2121
    2222Another problem is 'priority' column are regarded as required fields even I deselect priority column, thus join will be need every query.