In real terms if want to be able to support hundreds or thousands of users
then the process of connecting to a database, extracing the information and
then closing the connection isnt going to be quick or scalable enough.
The obvious solution is "Connection pools" - where a number of database
connections are opened (and kept open all the time) as the server is
started. I would expect most servers to support this but I only have
experience of how it is implemented in Weblogic.
If the data doesnt change that frequently or the queries are repeated
frequently, the you might also want to consider developing some kind of
caching mechanism to avoid hitting the database when it isnt really
necessary.
----- Original Message -----
From: J�n Dal Kristbj�rnsson <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, November 02, 1999 5:56 PM
Subject: Database connections
> Hello everyone.
>
> I've been using ASP for quite a while now and I've been handling all
> database connections by connection strings, instead of going through a
> System DSN. I haven't learned much about JDBC yet and I'm curious to know
> what the fastest way is, in JSP, to create a database connection. I'm sure
> there are several ways to do that, but I need to do it in a manner which
> won't be much load on the webserver if hundreds, or even thousands of
people
> are viewing my pages daily. Can anyone give me an idea of what to look for
> and where? Or better yet, does anyone have an actual source code example?
>
> Also, I'm running Microsoft's IIS server v4.0 and SQL server v7.0. Where
can
> I find the drivers I need for JSP to make the fastest database connection?
>
> Thank you for your help.
>
> Jon Dal Kristbjornsson
> [EMAIL PROTECTED]
>
>
===========================================================================
> To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff
JSP-INTEREST".
> FAQs on JSP can be found at:
> http://java.sun.com/products/jsp/faq.html
> http://www.esperanto.org.nz/jsp/jspfaq.html
>
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
FAQs on JSP can be found at:
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html
