We're updating the issue view to help you get more done. 

perfomance problem in id search

Description

Searching an object in CA via the oject ID sometimes causes massive performance problems that can not be exactly reproduced.

/var/log/mysql/mysql-slow.log shows the SQL statement for this action:

  1. Query_time: 65.325917 Lock_time: 0.000070 Rows_sent: 0 Rows_examined: 45812789
    INSERT IGNORE INTO ca_sql_search_search_final
    SELECT swi.row_id, SUM(swi.boost)
    FROM ca_sql_search_word_index swi INNER JOIN
    ca_sql_search_words AS sw ON sw.word_id = swi.word_id WHERE
    ((sw.word LIKE 'lca_000845278%'))
    AND
    swi.table_num = 57
    GROUP BY swi.row_id;

Any idea what to do here?

Thanks,

Christoph

Environment

Linux nut 3.2.0-4-amd64 #1 SMP Debian 3.2.68-1+deb7u4 x86_64 GNU/Linux

Assignee

User known

Reporter

Christoph Christoph

Labels

None

Components

Affects versions

Priority

Major
Configure