a servlet to access two db at the same tiem

[RandyTh]

I am trying to create the servlet that searchs tables with the same
strcuture but on different DB( Oracle and MSSQL ) and get search result
based on the search condition specified. Currently I am going one by one to
through the SQL sentence and assemble the search result. However, the each
table has about 400000 rows so takes time get all result
back to the browser. I was thinking if i can throw the sql sentence to each
table on the difference db at the same time
time takes to get the search result will be shorter. Is it possible to do
this?

W

 

[Richard Huddleston]

I am trying to create the servlet that searchs tables with the same
strcuture but on different DB( Oracle and MSSQL ) and get search result
based on the search condition specified. Currently I am going one by one to
through the SQL sentence and assemble the search result. However, the each
table has about 400000 rows so takes time get all result
back to the browser. I was thinking if i can throw the sql sentence to each
table on the difference db at the same time
time takes to get the search result will be shorter. Is it possible to do
this?

W

Yes

 

[Malte]

I am trying to create the servlet that searchs tables with the same
strcuture but on different DB( Oracle and MSSQL ) and get search result
based on the search condition specified. Currently I am going one by one to
through the SQL sentence and assemble the search result. However, the each
table has about 400000 rows so takes time get all result
back to the browser. I was thinking if i can throw the sql sentence to each
table on the difference db at the same time
time takes to get the search result will be shorter. Is it possible to do
this?

W

Use multithreading. If the two database systems are on different
machines, you should see a big improvement.
You are not going to put 400K rows unto a browser, I take it.