The web app is slow.
Running the same query on a laptop with a consumer ssd returns instantaneous results, while on my setup it can sometimes take up to 10-15 seconds to display the results. Same sql express iis and database. My hunch is the disk is not optimized for sql performance.