On Jan 25, 2008 1:01 PM, Floor Terra <floort@xxxxxxxxx> wrote: > If all these apache/php processes are a problem, you could try a > different setup: > Write a SOAP (or silmilar) webservice in a language that does support > proper > threading. Now call your SOAP function from your php script to send the > results > to the browser. soap is a great idea; i was thinking something along the same lines; only of using rest rather than soap. by setting up squid as a reverse proxy and then exposing a simple rest api (which the squid box proxies), you can easily cache these big results on an intermediate system. and if youve got a few bucks laying around; you can fill that system up w/ some ram and the results will be cached in memory rather than on disc. one of the issues with the squid approach is stale data. there are other options as well, such as memcache, or apc, if youre only running the cache on one system. i think the squid option is somewhat popular for its simplicity though. -nathan
