Re: [JBoss-user] best way to access db

[Burkhard V. <Bur...@gm...>]

Hi,
the key part you should have a look at is the jboss-pool. It provides
connection pooling of database connections, which are costy to instanciate
at first, the reuse and the caching of stored procedures makes (at least
where I use this) my applications significantly faster. If you need MANY
connections use a huge connection pool (and see that your db supports it),
which will eat up memory as wild (especially with oracle) but will boost
your speed. In terms of database performance I had good results using M$ SQL
Server (yuck) but their JDBC-Driver is crap! Try another commercial one like
sprinta.
hth
Burkhard
----- Original Message -----
From: "Stefan Groschupf" <sg...@me...>
To: <jbo...@li...>
Sent: Friday, May 24, 2002 4:50 PM
Subject: [JBoss-user] best way to access db


> Hi,
> I'm sorry for may be a out topic question, but I need some hints to start
my
> research work..
> Me and some guys planning to write a cluster able open source application
> (no ejb project) and want use the wonderful :) JBoss OS as backend.
> We want write some Mbeans to implement our application logic. Our
> application produce much data base traffic (data mining).
> So now I'm think about the best way to communicate with a data store.
>
> For us it's very important to have a fast db access. So I try to learn
more
> about a  direct JDBC connection, using entry beans or access  the object >
> relational mapper?
> Of curse jdbc must be the fastest way, I can imagine that it can be very
> useful to store and load a DOM Object of my data to the database.
> But may be on the other hand,  its very easy to use the ejbs in a cluster
> environment.
>
> Can someone give me any hints what's the most interesting technique for my
> problem?
>
> Thanks
> Stefan
>
>
>
>
> _______________________________________________________________
>
> Don't miss the 2002 Sprint PCS Application Developer's Conference
> August 25-28 in Las Vegas -- http://devcon.sprintpcs.com/adp/index.cfm
>
> _______________________________________________
> JBoss-user mailing list
> JBo...@li...
> https://lists.sourceforge.net/lists/listinfo/jboss-user
>