Hi, Having some problems here while computing some stats with OTRS stats module. I made a customized stats form to allow us compute how many tickets are opened each month by each Customer Company's ID, if I try to run it on a year (01/01/2007 to 31/12/2007) and choose Print as output ( PDF output ) I get what I can probably call a "timeout" between 3 or 4 minutes when stats are computed returning me back with a 500 Internal server error.
My webserver logs are giving me : [Mon Sep 17 17:03:14 2007] [error] [client 10.1.6.3] Premature end of script headers: index.pl, referer: http://otrs-test/otrs/index.pl?Action=AgentStats&Subaction=View&StatID=4 I can see in a 'show full processlist' mysql shell that a lot of queries are passed to MySQL, it seems to me that the process is taking long time to achieve and a timeout occurs before the end | 633 | otrs | localhost | otrs | Query | 0 | Copying to tmp table | SELECT DISTINCT st.id, st.tn, st.create_time_unix FROM ticket st, queue sq , ticket_history th WHERE sq.id = st.queue_id AND st.id = th.ticket_id AND LOWER(st.customer_id) IN (LOWER('SENTOR') ) AND st.create_time <= '2007-01-31 23:59:59' AND st.create_time >= '2007-01-01 00:00:00' ORDER BY st.create_time_unix DESC LIMIT 100000000 | For informations, we have almost 3900 tickets on database and 125 Customer Companys. Has anyone already encountered such problems and/or see any things that could be set to avoid this behaviour please ? Thanks by advance for your answers and time. Best regards, Laurent MINOST
_______________________________________________ OTRS mailing list: dev - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/dev To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/dev
