>The right way to do this is via Asynchronous request processing and offloading the query to another machine if the CPU load is heavy for this task. In addition, to freeing the server pool and not tying up IIS threads, you also get a chance to provide feedback as you're doing the search to let your users actually see something happening.
Thanks, if I have to keep the same infrastructure, I'll go with asynchronous mode for that specific situation. But, because of PHDBase issues I have, I am thinking of using SQL Server for the search engine. The test I did two years ago were equal to PHDBase. However, I haven't tested with a large table which is what I will do shortly.