[horde] Horde Implementation Going South

[Dave Cunningham]

Yeah, I have no idea what this query is for.

Can anyone help?

Dave


-----Original Message-----
From: Andrew Morgan [mailto:morgan at orst.edu]
Sent: Thu 9/6/2007 1:20 PM
To: Dave Cunningham
Cc: Jan Schneider; horde at lists.horde.org
Subject: RE: [horde] Horde Implementation Going South
 
On Thu, 6 Sep 2007, Dave Cunningham wrote:

> Unfortunately, this was the same after running both an analyze and an optimize on the tables...
>
> This still comes in with no key.
>
> And, I think my database may be running even slower today, although that may be due to more load.
>
> Dave

Ahh, if I actually use your query (minus your custom fields), then it 
doesn't use the primary key:

mysql> EXPLAIN SELECT object_id, owner_id, object_type,
     -> object_members, object_uid, object_name,
     -> object_email, object_alias, object_cellphone,
     -> object_homeaddress, object_homephone,
     -> object_company,
     -> object_title,
     -> object_workaddress, object_workphone,
     -> object_fax, object_notes, object_freebusyurl
     -> FROM turba_objects WHERE object_id IN (0);
+----+-------------+---------------+------+---------------+------+---------+------+--------+-------------+
| id | select_type | table         | type | possible_keys | key  | key_len 
| ref  | rows   | Extra       |
+----+-------------+---------------+------+---------------+------+---------+------+--------+-------------+
|  1 | SIMPLE      | turba_objects | ALL  | PRIMARY       | NULL | NULL 
| NULL | 203423 | Using where |
+----+-------------+---------------+------+---------------+------+---------+------+--------+-------------+


I think in this case, "WHERE object_id IN (0)" matches enough rows (about 
40% on my system) that it doesn't bother using the index.

Anyways...  This is all very interesting, but we need to know why Turba is 
making such an odd query!

 	Andy