Writing a CGI to query DB

[Bighead]

On Nov 10, 7:18 pm, TheFlyingDutchman <zzbba... at aol.com> wrote:
> 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?


It takes 10 minutes to run this SQL. Squid's error message pops up in
about 5 minutes.