Click here to Skip to main content
15,924,039 members
Home / Discussions / Web Development
   

Web Development

 
GeneralFileSystemObject Problems Pin
Dion15-Mar-03 15:21
Dion15-Mar-03 15:21 
GeneralRe: FileSystemObject Problems Pin
Philip Patrick19-Mar-03 10:06
professionalPhilip Patrick19-Mar-03 10:06 
GeneralQuestion about ONSELECTSTART event of HTML body. Pin
George215-Mar-03 1:45
George215-Mar-03 1:45 
GeneralRe: Question about ONSELECTSTART event of HTML body. Pin
Paul Watson16-Mar-03 22:50
sitebuilderPaul Watson16-Mar-03 22:50 
GeneralRe: Question about ONSELECTSTART event of HTML body. Pin
George217-Mar-03 1:30
George217-Mar-03 1:30 
GeneralRe: Question about ONSELECTSTART event of HTML body. Pin
DFU2317-Mar-03 14:19
DFU2317-Mar-03 14:19 
GeneralDatabase connection Pin
TPN15-Mar-03 0:26
TPN15-Mar-03 0:26 
GeneralRe: Database connection Pin
Paul Watson16-Mar-03 22:34
sitebuilderPaul Watson16-Mar-03 22:34 
Don't do it that way is the simple answer.

There are two ways you should do it, based on the traffic and resources of your site.

First way is for small sites where scalability etc. is not as important and where you cannot afford to do things the second way. This is to open the connection each time you need it and then close it right after you have used it. Open late, close early.

The second way is to use a COM component which has a pool of database connections. Your ASP code then never talks directly to the database, but rather speaks to your data access layer which is in the COM component and which manages the connections. There is a very good article on pooling right here on CP (but I can't find it. Just look for database connection pooling or thereabouts.)

Application.Lock is probably a bad idea because you then have to managed it very carefully and have a transactional system. What happens if an error occurs after an Application.Lock but before the unlock? Your error handling has to be very good and really it sounds like a nightmare.

Paul Watson
Bluegrass
Cape Town, South Africa

Macbeth muttered:
I am in blood / Stepped in so far, that should I wade no more, / Returning were as tedious as go o'er

DavidW wrote:
You are totally mad. Nice.
GeneralRe: Database connection Pin
TPN17-Mar-03 3:58
TPN17-Mar-03 3:58 
QuestionThe best way to manage user session ? Pin
TPN14-Mar-03 23:59
TPN14-Mar-03 23:59 
AnswerRe: The best way to manage user session ? Pin
Thesisus17-Mar-03 10:33
Thesisus17-Mar-03 10:33 
GeneralRe: The best way to manage user session ? Pin
TPN17-Mar-03 16:24
TPN17-Mar-03 16:24 
GeneralRe: The best way to manage user session ? Pin
Florin Ochiana27-Mar-03 13:07
Florin Ochiana27-Mar-03 13:07 
Questionhow browser remember's a link Pin
uzwa14-Mar-03 10:40
uzwa14-Mar-03 10:40 
AnswerRe: how browser remember's a link Pin
Torsten Mauz14-Mar-03 15:01
Torsten Mauz14-Mar-03 15:01 
GeneralEntertainment News Service Pin
perlmunger14-Mar-03 9:22
perlmunger14-Mar-03 9:22 
GeneralRichTextBox doubt Pin
Smitha Nishant14-Mar-03 5:09
protectorSmitha Nishant14-Mar-03 5:09 
GeneralSend mail in a free asp hosting. Pin
one_puppy13-Mar-03 15:37
one_puppy13-Mar-03 15:37 
GeneralRe: Send mail in a free asp hosting. Pin
Vasudevan Deepak Kumar14-Mar-03 3:26
Vasudevan Deepak Kumar14-Mar-03 3:26 
GeneralFont sizes Pin
Brakanjan13-Mar-03 4:09
Brakanjan13-Mar-03 4:09 
GeneralRe: Font sizes Pin
Jonathan32113-Mar-03 16:59
Jonathan32113-Mar-03 16:59 
GeneralRe: Font sizes Pin
Brakanjan16-Mar-03 22:11
Brakanjan16-Mar-03 22:11 
GeneralRe: Font sizes Pin
Ansch17-Mar-03 13:31
Ansch17-Mar-03 13:31 
Questionvalign equivalent in CSS? Pin
Jörgen Sigvardsson13-Mar-03 3:23
Jörgen Sigvardsson13-Mar-03 3:23 
AnswerRe: valign equivalent in CSS? Pin
Richard Deeming13-Mar-03 6:07
mveRichard Deeming13-Mar-03 6:07 

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.