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