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.)
|
