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