The "problem" is that I want to optimize the storing of incoming messages.
The use of database connections was just an observation. I thought that the CMP
engine would use several connections to be able to save the entity beans faster.
We increased the sequence block size and got better performance, but it's still
to slow. Increasing it further made it slower. Right now we use blocks of 50.
/Markus
> What is the actual problem? Why do you think that if only one connection
> is used it is not optimized?
>
> Markus H�rnvi wrote:
>
> > Hi!
> >
> > I have a MDB reading a constant stream of messages from a Queue. The MDB
> is
> > storing the messages through two CMP entity bean with a CMR.
> > The data written to the database will be read but never updated.
> > I would like to optimize the process from MDB to database.
> >
> > When I look at the use of database connections, it seems that only one is
> in
> > use. I guess this has something to do with my use of transaction
> attributes.
> >
> > I use the default transaction settings on Oracle which I believe is
> > READ_COMMITED. The CMP has "Required" transaction setting. The MDB uses
> > transaction-type="Container" and "Required".
> >
> > Primary keys are issued by a session bean that requests blocks of keys from
> an
> > entity bean. This bean uses "RequiresNew" and row locking.
> >
> > What would be the best settings to tweak?
> >
> > Thanks in advance!
> >
> > /Markus
> >
> >
> >
> >
> > -------------------------------------------------------
> > This SF.Net email sponsored by: ApacheCon 2003,
> > 16-19 November in Las Vegas. Learn firsthand the latest
> > developments in Apache, PHP, Perl, XML, Java, MySQL,
> > WebDAV, and more! http://www.apachecon.com/
> > _______________________________________________
> > JBoss-user mailing list
> > [EMAIL PROTECTED]
> > https://lists.sourceforge.net/lists/listinfo/jboss-user
> >
> >
>
>
>
>
> -------------------------------------------------------
> This SF. Net email is sponsored by: GoToMyPC
> GoToMyPC is the fast, easy and secure way to access your computer from
> any Web browser or wireless device. Click here to Try it Free!
> https://www.gotomypc.com/tr/OSDN/AW/Q4_2003/t/g22lp?Target=mm/g22lp.tmpl
> _______________________________________________
> JBoss-user mailing list
> [EMAIL PROTECTED]
> https://lists.sourceforge.net/lists/listinfo/jboss-user
>
-------------------------------------------------------
This SF. Net email is sponsored by: GoToMyPC
GoToMyPC is the fast, easy and secure way to access your computer from
any Web browser or wireless device. Click here to Try it Free!
https://www.gotomypc.com/tr/OSDN/AW/Q4_2003/t/g22lp?Target=mm/g22lp.tmpl
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user
