MQSeries.net :: View topic

venky · Posted: Mon Jul 10, 2006 8:11 pm Post subject: JDBC Adapter performance.

Hi All,

we are planning to use JDBC adapter to retrieve and insert data into Database tables. we have 2 scenarios:

1. Multi level children with N Cardinality (Example).
Parent
Child 1[N]
Child 1A [N]
Child 1B[N]
Child 2[N]
in this scenario, would it be better to directly query the tables or would it be better to create views and query the views or use stored procedure to query only the required data ? (Or am I missing any other better method to do this ? )
if anyone of you have done this in the past, please share your experience.

2. We have 2 database tables (A, B) ( in 2 different databases), we have to sync up the tables (move data From A to B ) every 10 minutes. ( Approximately 5000 rows).
In this case will the JDBC adapter serve the purpose ?

Thanks in advance,
Venky.