Recordset Retrieval in Servlets

Dear All,

I am using a Servlet to access the Database and read a recordset. The issue I am having is that the query executes in the backend in a fraction of a second. But the fetching of data from the database to the application server takes a very long time.

I am using CallableStatement Interface and also setting a prefetch value which is appropriate. The issue is that though the number of records are few, it takes 4-5 seconds to fetch the data. This results in very poor performance of the system.

Could someone provide some help quicly since this is an extremely urgent requirement.

Thanks

Menon

[639 byte] By [rvmenona] at [2007-10-2 18:42:11]