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 <[EMAIL PROTECTED]> Subject: Re: [otrs] time accounting otrs 2.0.4 To: "User questions and discussions about OTRS.org" <[email protected]> Message-ID: <[EMAIL PROTECTED]> 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
begin:vcard fn:Johan Bijlsma n:Bijlsma;Johan org:Rotaform;ocr print service adr:;;Zilverstraat 2;Lelystad;Flevoland;8211 AN;Nederland email;internet:[EMAIL PROTECTED] title:Systeembeheerder tel;work:0320 279900 tel;fax:0320 279999 tel;cell:06 30290785 x-mozilla-html:FALSE url:http://www.rotaform.nl version:2.1 end:vcard
_______________________________________________ OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs Support oder Consulting für Ihr OTRS System? => http://www.otrs.de/
