[dev] [cvs] commit: whups/scripts/sql whups.sql whups/scripts/upgrades 2007-01-16_add_ticket_dates.sql

[Onyx Raven]

I was writing some reporting queries for my install, and added the
quite a few indices - it took > 2 minutes for about before, < .5
seconds after (about 50 result rows, 7000 tickets with something like
24000 comments/logs).  I used explain select to find what needed
indices.

I'll compare my list against the current indices in CVS and get back to you

On 1/19/07, Duck <duck at obala.net> wrote:
> On Friday 19 January 2007 00:14, Jan Schneider wrote:
> >>>    scripts/upgrades     2007-01-16_add_ticket_dates.sql
>
> Theare are still tables without indexes. Like
> whups_types_queues
> whups_attributes
> whups_tickets_listeners
> and the new whups_queries
>
> Duck
>
> --
> Horde developers mailing list - Join the hunt: http://horde.org/bounties/
> Frequently Asked Questions: http://horde.org/faq/
> To unsubscribe, mail: dev-unsubscribe at lists.horde.org
>