Click here to Skip to main content
15,918,889 members
Home / Discussions / ASP.NET
   

ASP.NET

 
AnswerRe: Asp.net code using vb [modified] Pin
amaneet18-Sep-06 5:22
amaneet18-Sep-06 5:22 
AnswerRe: Asp.net code using vb Pin
Guffa18-Sep-06 6:12
Guffa18-Sep-06 6:12 
QuestionHi Guys , i don't know how to deny an event Pin
Mohammed Amine18-Sep-06 4:50
Mohammed Amine18-Sep-06 4:50 
AnswerRe: Hi Guys , i don't know how to deny an event Pin
Not Active18-Sep-06 5:13
mentorNot Active18-Sep-06 5:13 
AnswerRe: Hi Guys , i don't know how to deny an event Pin
deepaks318-Sep-06 9:38
deepaks318-Sep-06 9:38 
Questioni'm wondering how many connections i have to use ? [modified] Pin
Mohammed Amine18-Sep-06 4:31
Mohammed Amine18-Sep-06 4:31 
AnswerRe: i'm wondering how many connections i have to use ? Pin
Not Active18-Sep-06 5:11
mentorNot Active18-Sep-06 5:11 
AnswerRe: i'm wondering how many connections i have to use ? Pin
Guffa18-Sep-06 6:22
Guffa18-Sep-06 6:22 
You use a separate database connection for each request. That's the only reasonable way to handle multiple users. Any attempt to share connections or keep them alive from one request to another will only result in using more resources.

It's true that there is a limit on the number of simultaneous connections, but that is rarely a problem unless you have written bad code. The database driver for Access has a limit of 64 simultaneous connections, and that is sufficient in most cases. If you have so many users that the number of connections is a problem, you have outgrown an Access database anyway.

Well written code minimizes the time each connection is open, so that the server can handle more requests with fewer connections open at the same time. Open the connection as late as possible, get your data, and close the connection as soon as possible.


---
b { font-weight: normal; }

GeneralRe: i'm wondering how many connections i have to use ? Pin
Mohammed Amine18-Sep-06 7:32
Mohammed Amine18-Sep-06 7:32 
AnswerRe: i'm wondering how many connections i have to use ? Pin
Guffa18-Sep-06 8:50
Guffa18-Sep-06 8:50 
AnswerRe: i'm wondering how many connections i have to use ? Pin
deepaks318-Sep-06 9:44
deepaks318-Sep-06 9:44 
QuestionControlling User Controls Pin
Dayekh18-Sep-06 3:57
Dayekh18-Sep-06 3:57 
AnswerRe: Controlling User Controls [modified] Pin
sundar15620-Sep-06 10:30
sundar15620-Sep-06 10:30 
QuestionRunning ASP.NET 2.0 project from localhost.... Pin
Kasic Slobodan18-Sep-06 3:29
Kasic Slobodan18-Sep-06 3:29 
AnswerRe: Running ASP.NET 2.0 project from localhost.... Pin
minhpc_bk18-Sep-06 15:30
minhpc_bk18-Sep-06 15:30 
GeneralRe: Running ASP.NET 2.0 project from localhost.... Pin
Kasic Slobodan28-Sep-06 4:50
Kasic Slobodan28-Sep-06 4:50 
GeneralRe: Running ASP.NET 2.0 project from localhost.... Pin
minhpc_bk28-Sep-06 22:14
minhpc_bk28-Sep-06 22:14 
Questionhow to create wizard web custom control in asp 2.0 Pin
shadesRulz18-Sep-06 3:28
shadesRulz18-Sep-06 3:28 
AnswerRe: how to create wizard web custom control in asp 2.0 Pin
Sathesh Sakthivel18-Sep-06 3:39
Sathesh Sakthivel18-Sep-06 3:39 
GeneralRe: how to create wizard web custom control in asp 2.0 Pin
shadesRulz18-Sep-06 4:21
shadesRulz18-Sep-06 4:21 
Questionuser controls Pin
ajmurdoch18-Sep-06 3:26
ajmurdoch18-Sep-06 3:26 
AnswerRe: user controls Pin
minhpc_bk18-Sep-06 15:35
minhpc_bk18-Sep-06 15:35 
GeneralRe: user controls Pin
ajmurdoch19-Sep-06 0:03
ajmurdoch19-Sep-06 0:03 
GeneralRe: user controls Pin
minhpc_bk19-Sep-06 0:35
minhpc_bk19-Sep-06 0:35 
GeneralRe: user controls Pin
ajmurdoch19-Sep-06 5:46
ajmurdoch19-Sep-06 5:46 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.