[horde] [whups] whups very slow after cvs update

[Volker Then]

Quoting Volker Then <vt at volkerthen.com>:

>
>
> Chuck Hagenbuch wrote:
>> Quoting Volker Then <vt at volkerthen.com>:
>>
>>> Yes, I had a look, but there is nothing suspicious to be found. I
>>> just can tell, that mysqld consumes up to 99% when horde/whups is
>>> querying the database. The upgrade tickets table (with "due date")
>>> is browsable with phpMyAdmin without any problems. Thereto the
>>> entire whups database is accessible with older versions of whups (as
>>>  of last month). So, I don't think it's a problem with the database
>>> but with the scripts accessing it.
>>
>> While it's processing, try opening a MySQL shell and typing "SHOW
>> PROCESSLIST".
>>
>
> Here's the relevant output:
>
> | 1528 | horde  | localhost | bugs   | Query   | 34   | Copying to tmp
> table | SELECT whups_tickets.ticket_id as id,
> whups_tickets.ticket_summary as summary, whups_tickets.user_id |
>
>

Hi Chuck,

it seems that the new version of Driver/sql.php fixed this.

Thanks! And thanks for implementing due dates in whups! Great.


Volker