[dev] [cvs] commit: horde/scripts/sql create.mysql.sql

Jan Schneider jan at horde.org
Sun Jul 2 05:12:29 PDT 2006


Zitat von Matt Selsky <selsky at columbia.edu>:

> selsky      2006-06-30 13:51:39 PDT
>
>   Modified files:
>     scripts/sql          create.mysql.sql
>   Log:
>   These indexes are not actually used in MySQL.  The query analyzer   
> always chooses the primary key index for the queries that we do.

Not when I ran the analyzer. Besides the SELECT 1 query, all SELECT  
queries used the new indexes. It might depend on the data structure,  
we should keep it in because it doesn't hurt as much as it might gain  
some extra performance.

Jan.

-- 
Do you need professional PHP or Horde consulting?
http://horde.org/consulting/



More information about the dev mailing list