[rt-users] Slow ticket search page becoming a problem

[Dirk Pape]

Hello,

--Am 18. November 2007 22:17:42 +0300 schrieb Ruslan Zakirov 
<ruslan.zakirov at gmail.com>:

> Script creates schema and data. The following query must use range
> search for the second table instead of 'ref'.

so this is from our site:

"
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 897
Server version: 5.0.32-Debian_7etch1-log Debian etch distribution

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> explain SELECT STRAIGHT_JOIN g.id FROM acl a, grp g WHERE
    ->     g.type = a.type
    ->     AND (
    ->         ( g.domain = 'RT::Ticket-Role' AND g.instance = 10 )
    ->         OR ( g.domain = 'RT::Queue-Role' AND g.instance = 3 )
    ->         OR ( g.domain = 'RT::System-Role' AND g.instance = 1 )
    ->     );
+----+-------------+-------+-------+---------------+------+---------+------+------+-------------+
| id | select_type | table | type  | possible_keys | key  | key_len | ref 
| rows | Extra       |
+----+-------------+-------+-------+---------------+------+---------+------+------+-------------+
|  1 | SIMPLE      | a     | ALL   | NULL          | NULL | NULL    | NULL 
|    2 |             |
|  1 | SIMPLE      | g     | range | grp1,grp2     | grp2 | 40      | NULL 
|    6 | Using where |
+----+-------------+-------+-------+---------------+------+---------+------+------+-------------+
2 rows in set (0.00 sec)

mysql>
"

As far as I understood this meens that "Server version: 
5.0.32-Debian_7etch1-log Debian etch distribution" is ok, isn't it?

Regards, Dirk.