Harshal,
You said:
Currently I am working on one form which is developed using d2k and
oracle 9i as database.
In that form the same result will be displayed within 1 sec.
"d2k" is Developer 2000, I presume?
Are you sure that the entire 8000 rows of the result set are returned
within one second?
The Oracle
JDBC driver returns result set rows in groups of 10 (ten),
by default.
This number can be increased using the "setFetchSize()" method(s).
See interfaces "java.sql.ResultSet" and "java.sql.Statement".
Also refer to the "JDBC Developer's Guide and Reference", part of the
Oracle documentation, that explains how Oracle's JDBC driver handles these
methods.
I suggest you use pagination.
I recommend searching the Internet for the terms "jdbc" and "pagination",
or "paging".
A user cannot possibly view 8000 rows in one shot.
Good Luck,
Avi.