This discussion is archived
0 Replies Latest reply: May 15, 2013 8:28 PM by 1008459 RSS

too many rows hangs the system ?

1008459 Newbie
Currently Being Moderated
Hello

On post staging server, query of 10,000 rows of data extraction on a DB is fine but on a Websphere application server HTML, it loads after long time, So when changed the query to result in 1000 rows then it loads faster. Performance issue?

Is it at the application server level or DB ? Perhaps! Pagination will help.
Could be caching issue on application server ?

Any ideas guys to resolve this ?



Note: Staging and Post staging servers have idential code. Oracle 10g, IBM AIX

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points