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