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" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> 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 > [EMAIL PROTECTED] > https://lists.sourceforge.net/lists/listinfo/jboss-user > _______________________________________________________________ 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 [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
