[otrs] Timeout while using Stats module

[Laurent Minost]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.otrs.org/pipermail/otrs/attachments/20070917/4e3c29f3/attachment.html