| | |
ADODB Connection
Please support our ASP.NET advertiser: $4.95 a Month - ASP.NET Web Hosting – Click Here!
![]() |
Hello All.
This seems like a simple question but i cannot find a solid answer anywhere.
Im in the middle of streamlining our web application for use on local network and external use.
When a form loads there are usually several blocks of code that run.
EG.
Fetch Title From Database
Fetch Items For Combo Lists To Populate
Fetch Saved Data To Insert Into Fields
NOW obviously there is some processing inbetween especially step 2 of filling combo lists which can contain anywhere between 1 - 1000 selections (not practical but it is the users choice if they want 1000)
I understand opening a connection to a database is a costly server action processing wise and also is time consuming. So is it better for me to maintain one connection to pass to these seperate methods on page load or open a new instance-return data-close connection inside each method.
cheers.
This seems like a simple question but i cannot find a solid answer anywhere.
Im in the middle of streamlining our web application for use on local network and external use.
When a form loads there are usually several blocks of code that run.
EG.
Fetch Title From Database
Fetch Items For Combo Lists To Populate
Fetch Saved Data To Insert Into Fields
NOW obviously there is some processing inbetween especially step 2 of filling combo lists which can contain anywhere between 1 - 1000 selections (not practical but it is the users choice if they want 1000)
I understand opening a connection to a database is a costly server action processing wise and also is time consuming. So is it better for me to maintain one connection to pass to these seperate methods on page load or open a new instance-return data-close connection inside each method.
cheers.
When Autumn Falls [ http://www.whenautumnfalls.co.uk ] &&
Designdotworks [ http://www.designdotworks.co.uk ] Web / Graphic / Software Design
Designdotworks [ http://www.designdotworks.co.uk ] Web / Graphic / Software Design
OK ill give it a whirl and see what is happening. User wise it could be from 10 - 100 users at any one time.
When Autumn Falls [ http://www.whenautumnfalls.co.uk ] &&
Designdotworks [ http://www.designdotworks.co.uk ] Web / Graphic / Software Design
Designdotworks [ http://www.designdotworks.co.uk ] Web / Graphic / Software Design
![]() |
Other Threads in the ASP.NET Forum
- Previous Thread: SHARED Whatever as String
- Next Thread: sending sms
| Thread Tools | Search this Thread |
.net 2.0 3.5 activexcontrol advice ajax alltypeofvideos asp asp.net bc30451 bottomasp.net browser businesslogiclayer c# c#gridviewcolumn checkbox class commonfunctions compatible confirmationcodegeneration content contenttype countryselector courier css dataaccesslayer database datagrid datagridview datagridviewcheckbox datalist development dgv dropdownlist dropdownmenu dynamic dynamically edit fileuploader fill findcontrol flash flv formatdecimal forms formview gridview gudi homeedition iframe iis javascript jquery listbox menu microsoft mouse mssql multistepregistration nameisnotdeclared news objects opera panelmasterpagebuttoncontrols problem redirect registration relationaldatabases reportemail rotatepage schoolproject security serializesmo.table silverlight smartcard smoobjects software sql sql-server sqlserver2005 ssl textbox tracking unauthorized validation vb.net video videos virtualdirectory vista visual-studio visualstudio web webapplications webarchitecture webdevelopemnt webdevelopment webprogramming webservice youareanotmemberofthedebuggerusers





