Hi All,
I have developed an application where in the application should search around 17000 items (rows) and display on UI. I have pl/sql function where it will return the search results but showing it on UI is taking hell lot of time (More than 45 minutes). Upon debugging i found that the while loop might causing the issue. Following is the code snippet:
while (rs != null && rs.next()) // rs is the result set returned by pl/sql function
{
// Setting the values to VO table.
}
Whatever i am printing inside while loop is not getting printed i mean the control stucked in while loop. Can anyone please tell me what i should do? It's quite urgent as we are moving this application to production.
JDeveloper version is 12.1.3