Any wordpress loading page ? something like timer/count down/ bar for user when they click search ?
Sorry my site with huge data and it take some time to complete search and most of my user do that
Use Google Custom Search and you won't have that problem.
How many posts do you have there?
No 600k posts database can cause WP search function to spend more than a second searching for anything (of course this might depend on your server), but custom searches can play a tricky part there.
Have you tried to search for all those "improved search" plugins at the wordpress site?
Yah 600k is not alot but enough to slow down a lot of speed and my db is increasing in high speed too, i use 3 dedi to run this site now, 1. publish . 2. DB 3. AD. So hardware should't be any problem for now and short future ....
Imagine 500 ppl search 4 gb of db in one time ? in peak hour it hit 1.5k user.
Normal wp search plugin won't help now i even done SPHINX custom WP plugin, it help but ain't that fast, now i doing custom index for the site, before everything complete, i just need a simple script/plugin that can tell my visitor "the site is running, just a bit slow" (only knowledge i have )
I was thinking about a similar problem recently. What I was planning to do is display a hidden animated GIF such as an egg timer or progress bar when the submit button is clicked. Then when the results page is delivered, this image disappears.
So the image has the CSS display:hidden property.