I have a couple of questions.
I have a site every page request access to the database.
Inc_Header.asp <--- Include file for everypage ( Keeps database connector )
Inc_Footer.asp <--- Include file for everypage ( Keeps database closing )
so basicly the way it should work
Pull Inc_header.asp
Open connection
Run script for page that is loaded
Pull Inc_footer.asp
close connection
well i am looking in my PROCESSLIST for SQL and it is showing a process but it show Sleep for Command
is there a reason there would be a process there if i have closed it?
if I publish this site for the public I don't want thousands of processes there..
How many connections/process will SQL allow before not allowing anymore?
Linear Mode
