How do you display a temporary page while SQL works?

jtown

A perfect example of this is when you search on forums like this one. Once you submit you query, it goes immediately to a temp page that says "Please Wait" or something of the sort. How do you do that?

TIA.

superwormy

I don't think that page actually waits for the query to be exectuted...

I think the query is executed way fast, and that page just uses a meta-redirect in the <head> html tag to redirect you.

Not sure why they do that... queries are in general pretty damn fast, usually you don't need to wait more than half a second... even for a big query.

Traduim

You can use a frameset of 100%,0 with 2 pages.
The first contains the "Wait until I'm ready" message, the second does the SQL&PHP work and, once the second page is loaded, you call a Javascript function that hides the first frame and shows the second one.

There are other ways for doing so, but that's what I do 🙂

Note:
This is the Javascript function:

var x=true;
var padre = parent.document.getElementsByTagName("frameset")[0];
function cambio() {
if (x) {padre.rows = "0,*";}
else {padre.rows = "*,0";}
}

jtown

oh, the specific situation is ...

a file is uploaded and this file could could be as large as say 3 megs of just text.
while the file is uploaded there isn't anything we can do, but after it receives the file we have to create our text search indexes on all the lines etc. and it actually takes quite a bit of time (less than a couple seconds) to process all the data.

We just don't want people to get impatient and cancel the operation. any other ideas? the frame idea is a good idea.