Website Hangs when loading ASP Page
Hey guys, got a problem which I hope to be enlightened on.
Currently I'm building a website (Classic ASP + mySQL DB) that holds a cache of daily stock prices and have written an algorithm to calculate the best performing stock within a period of time.
This algorithm will read the mySQL database and calculate % of stock gain days, % of value gain etc, and will take a period of time (seconds to minutes, depending of the period of timeframe) and during this point of time, when I try to open a new tab on the browser and try to access the website again (acting as a second user), it would not respond until the algorithm is complete.
Can someone shed some light on this for me?
P.S, read from somewhere that the algorithm might have used too much of the server's resources, hence the website can only be available after it is completed. Not sure how true that might be.