[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