on 06-10-2008 3:26 PM
Hello all,
I would like to know if there is a way to speed up a JDBC connection between PI 7.0 and an Oracle base ?
Is there tuning to do in PI or on the Oracle side ?
Thanks by advance,
JP
Hi,
Go thru the blogs it may help u :
http://help.sap.com/saphelp_nw04/helpdata/en/21/68f1f860454a2396aa709f9b91a685/frameset.htm
http://www.j-nine.com/pubs/optjdbc/optjdbc.html
http://www.experts-exchange.com/Database/MySQL/Q_23300739.html
http://www.onjava.com/pub/a/onjava/2001/12/05/optimization.html
Regards,
Vinod.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks all for the different answers
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Jean,
Tuning Database Connectivity
Use
Access to the persistence layer typically slows down client request processing, since it involves the establishment of a database connection, and database operations are time-consuming. With J2EE Engine, you can configure database connection pools.
Activities
JDBC Connector Service enables you to configure a database connection pool for each DataSource you use. You can set the initial and the maximum number of connections in the pool, as well as their lifetime. For more information about these settings, see Managing Connection Pooling.
Guidelines
· Since each client request on the J2EE Engine server processes runs in a separate application thread, you should configure the number of database connections in the pool considering the maximum number of application threads set on the server processes. The application thread number is also the maximum number of client requests that are processed concurrently on the server. A single client may use several database connections, and you can define the application thread number and the number of pooled database connections considering the average connections-per-user number. The application thread number is configured in the properties of Application Thread Manager. For more information, see Configuring the Thread Pool.
However, when you define the maximum number of pooled connections, you should also take into account the number of server processes that you have in your cluster. If the overall number of connections is too big, this may deteriorate the database performance.
· To limit the time during which an application thread remains locked while waiting for a database connection, you can decrease the value of the Maximum Time to Wait for Connection property for the DataSource. For more information, see Managing Connection Pooling.
if found worth pls do the req
Thanx
Sampath
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hi jean
inegrating with DATABASES made easy part1
/people/laxman.molugu/blog/2006/08/13/integration-with-databases-made-easy-150-part-1
Save time with generalized JDBC datatypes
/people/alessandro.berta/blog/2005/10/04/save-time-with-generalized-jdbc-datatypes
regards
chandra
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
There is no such way to speed up the JDBc connection.
But refer
Fine-Tuning the Java Database Connection
Thanks
Swarup
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
10 | |
10 | |
9 | |
7 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.