>-----Original Message-----
>From: Alex Cheung Tin Ka [mailto:[EMAIL PROTECTED]]
>
>
>Dear All,
> I am going to ask an old question about how to generate a
>pending page for my cgi script.
> Here is my current situation. I have got a time consuming
>query to the database. After prepare the data, I should post
>those data on to a html page. But the problem is the accessing
>time is too long and the browser is going to be time out.
As an intermediate fix I would suggest setting the time out on the web
server to something higher. If you are using apache this can be done in the
http.conf file. Not meaning to sound ignorant are there any ways to optimise
the query. I work with SQL and the DBA's here never cease to amaze me when
they edit a bit of my SQL and make it run a lot faster.
>I would like to know is there any solution for this. How
>to making a pending page that waiting for the query?
I use the net a lot and when I encounter a page that takes a long time I do
not have the patience to wait for it. If the SQL or display of the data is
slow it does not matter if the person is on a dial up or on an E1. On the
other hand if this is internal then the people are more apt to wait as they
will probably need the data.
Harry
*************************************************************************************
COLT Telecommunications
Registered in England No. 2452736
Registered Office: Bishopsgate Court, 4 Norton Folgate, London E1 6DQ
Tel. +44 20 7390 3900
This message is subject to and does not create or vary any contractual
relationship between COLT Telecommunications, its subsidiaries or
affiliates ("COLT") and you. Internet communications are not secure
and therefore COLT does not accept legal responsibility for the
contents of this message. Any view or opinions expressed are those of
the author. The message is intended for the addressee only and its
contents and any attached files are strictly confidential. If you have
received it in error, please telephone the number above. Thank you.
*************************************************************************************
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
