[otrs] Re: time accounting otrs 2.0.4

26 May 2006

      Hi Christian,

Hardware Proliant ML370R03 X2800
OS is RedHat 8
Database is MySQL 4.1.1

Tables
article is 4,848 records
ticket is 1,252 records
time_accounting 2,090 records

when i use this query;
SELECT `ticket_id`, sum(time_unit) FROM `time_accounting` WHERE
`create_time` >= '2006-04-01 00:00:00' and `create_time` <= '2006-04-31
23:59:59'GROUP BY `ticket_id`

i get the following results.

februari (219 total, Query took 0.0261 sec)
march (294 total, Query took 0.0170 sec)
april (238 total, Query took 0.0718 sec)

Best regards,

Johan

Message: 3 Date: Wed, 24 May 2006 16:56:19 +0200 From: Christian
Schoepplein  Subject: Re: [otrs] time
accounting otrs 2.0.4 To: "User questions and discussions about
OTRS.org"  Message-ID:
<20060524145618.GI4183@athlon.schoeppi.net> Content-Type: text/plain;
charset="us-ascii"
Hi Johan,

On Wed, May 24, 2006 at 09:05:31AM +0200, Johan Bijlsma wrote:
...
...
When I use time accounting i get after some minutes a Internal Server
Error. This problem occurs from month 3. Month 1 en 2 generates reports
without a problem.
Sounds like a timeout problem or to much data are transmitted.

How many ickets are stored in your DB? On which hardware is OTRS
running? What database is in use?
...
...
Johan Bijlsma.
Best regards,
Christian