Hi,
I'm running a query against a Table with around 70 000 rows.
There are 45 Columns of which 12 are varchars.
The database query returns 1000 rows.
Using Query Analizer, the response is sub-second.
Using our application, JBoss times out.
The
PortableRemoteObject.narrow(i.next(),Bean.class);
method seems to be delaying the response.
Please can someone suggest how i can prevent timeouts without adjusting the transaction timeout interval in JBoss.
Thanks,
Mark.