I have a question related to leave a SQL connection open or close it.
Here is the scenario...
I have an Intranet page that monitors a Robot, that webpage needs to be up 24hours/7days a week.
Robot sends information to a SQL database every couple of seconds or minutes depending on the work it performs.
My page has an AJAX Timer that triggers every 5 sec, in that page I have to query the database (simple SELECT - no more then 15 lines) and show my info in a gridview.
The question is: Should I open the connection and leave it open or should i open and close every 5 secs?
View Complete Post