I did 3 tier program using SQL server. One program at client side, one server program and a SQL 2k db. the db just hold the data, the server program doing the request and processing. Let's say I have 30000 records in a table and want to query the table in a 2 cycle query, meaning a loop in other loop. It will take the whole CPU to process and this will make the server like hanging.
How to avoid this situation. If can, I want to see the process running with status of the searching displayed interactively on the server program interface, so that I know the process is still running.
Please help, if necessary I will program the code for you Experts to have a look and comment.