Implemetation of pagging to improve performance
Posted on 2004-09-23
We are having screen with three frames.
First frame is having 60 columns with first column hyperlinked.
Second and thrird frame will be hyperlinked based on the first frame.
The query on the first frame is dynamic something like this
SELECT A,B,Max(C),D,E .. from table1,table2 where join between table1 and table2 and other
conditions group by field names other then max()
The problem is the query is returning more than 10000 records and to display 10000 records on same
page is not possible.. I am thinking of paging but because of use of max(), group by and order by clause
i cannot take the count.
To scroll thru resultset is also time consuming..
Can anybody suggest me how do i implement pagging concetp here.
I would be more than happy...This would improve the performance of my tool a lot....
Thanks in advance.