[phpesp-dev] Re: Timeouts on csv downloads

[James E. F. <jf...@uv...>]

Paul R. Jackson wrote:
> I'm wondering if anybody else has timeout problems when downloading the data
> from phpESP. 
> 
> Our server is certainly no super computer (read: PII 350mhz) and I realise
> that this is what causes the problem really but given our surveys are
> relatively small (500+ responses, 100+ questions) I think everybody will hit
> this problem sooner or later if their surveys get large enough.
> 
> Initially it was the php max-execution-time that was breaking it but I
> increased that significantly and now it's the i.e. connection timeout. This
> too can be increased and/or you can use mozilla which seems to have a longer
> timeout.
> 
> The main problem for me is that it falls over in a very graceful manner and
> users don't know what the hell is happening.
> 
> We will be upgrading or server in the near future so the problem for me will
> probably evaporate but I am interested to see if other people are
> experiencing the same issue from time to time.
> 
> Paul

Paul,

One way to speed up phpESP is to add indicies to the mysql tables.  By 
using an index lookup rather than a search, mysql can process queries 
faster.  I believe there was some discussion of this in the past on the 
list, perhaps the poster could re-post a summary.

-James

(BTW, the list address is phpesp-devel@... the phpesp-devel-admin@... 
mail just goes to me.)