Firstm I'm using
I'm solving the problem which is to retrieve a data from a separated databases and to render it into a web page. The web project is on the
JSF 1.2). Presently that particular feature's implemented by using
dblink query, which retrieves a tables from a separated databases and
FULL OUTER JOIN these tables. Is there a more efficient way to do that?
UPD: I need to retrieve that data in a real time, after
http-request comes from the client.
UPDD: The page to render contains 100-300 records each of them consist of 10-15 varchar(30), bigint, numeric or integer fields. Correspondingly I need to retrieve 100-300 records per request. The thing is erlier it worked in the way to retrieve all data from the
criteria.list() with futher sorting, paging etc... . By now I've done that to retrieve the only data which is need to render. I've written native
sql-query for that but it works even more slowly... It seems I need another way to solve that.