Right.
In a distributed (let's use a simple hub-and-spoke for discussion purposes)
architecture, you might think about using ODI's Javelin at the web server (spoke)
level. So you might have several web servers to handl the traffic of, say, 1000
simultaneous users. Each server has an image of the (relational) database tucked
away in its Javelin (or whatever other OODB) local datastore, and maintains
multiple connections to the server. An OODB is nice 'cuz you get transparent
persistence from the application-programmer's point-of-view.
Assuming that the nodes on the spokes don't care about each other's updates (say in
an e-commerce site), then the traffic is all from the spokes into the hub (where
your RDBMS lives), and not around the rim of the wheel. Get yourself some big iron
to host your RDBMS and you're in bidness. You can even do batch updates instead of
real-time updates to the RDBMS, given that the OODB has already persisted the
objects to disk. This will save you some overhead vs. creating prepared statements
on the fly for each transaction.
Using RDBMS replication/mirroring and a guaranteed messaging mechanism (say MQ or
one of the newbies like Vitria), this model may be extended into a federated
architecture with multiple RDBMSs participating.
Just my opinion, of course.
-bml
Paul Allton wrote:
> 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
--
_________________________________________________________________________
Brian M. Long RandomWalk Computing, Inc. [EMAIL PROTECTED]
'Apollo was astonished / Dionysus thought me mad' -Hemispheres, 14:52
__________________________________________________________________________
===========================================================================
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
