Search buffer page?

[rsmithinfo]

Hi All,

I have a reasonably large database table (1.8 million records) that sometimes takes ages to search and so the php times out. I was wondering how easy it is to put up a page that says 'Search in progress..' or something similar while the sql executes?

Does that make sense and has anyone got some advice?

Thanks

[qolbu]

maybe use flush ???

[rsmithinfo]

It's not the PHP script thats holding up the process as it only displays around 25 records.

It sticks on the line where it executes the query to the MySQL database.

What I want to do is display a page between the search page and the results page to display whilst the search is being performed?

[rsmithinfo]

No one got any idea?You see it on quite a lot of sites