Hello!
I have a series of IFRAMEs in which different ASP (with SQL) pages load. These modules all run different queries off of the same server, and they're all trying to hit the server at the same time.
<div id="1">
<iframe src="1.asp"></iframe>
</div>
<div id="2">
<iframe src="2.asp"></iframe>
</div>
<div id="3">
<iframe src="3.asp"></iframe>
</div>
It was my thought that these frames would load independently of one another, but they aren't, and I assume they aren't because they're hitting the same server. In fact, they load in order.
Each ASP file has dramatically different ASP/SQL contained within it; some queries are fast, others take time (hence the reason for different IFRAMEs).
Should I be leaving CONNs open, or closing recordsets, or pooling, or ???