Writing a CGI to query DB

[TheFlyingDutchman]

On Nov 9, 8:33 pm, Bighead <Xue.Huic... at gmail.com> wrote:
> Hi,
>
> I am currently working on a CGI deployed on an Apache server, which,
> given an arbitrary SQL, fetches raw data from a remote DB server and
> return them in a HTML page. This CGI works fine on quick SQLs.
>
> But when I try to run a slow SQL on this CGI, through a Squid Proxy, I
> always get the Error message from Squid: Zero Sized Reply, after 5
> minutes.
>
> The SQL itself is correct, since I have tried it directly on the DB
> server. So what do you think might cause the problem? Thank you.

Slow SQL = query that takes a long time? How long does the query take
if you run it on the same machine as the DB server without a Squid
Proxy?