on and opted for paging at the database layer.
To do this I am retrieving the no of records using the following query
and then again executing another query which actually limits the no of
records to 20. I am facing performance issues with the query. Since I am
executing this complex query
ase layer.
> To do this I am retrieving the no of records using the following query
> and then again executing another query which actually limits the no of
> records to 20. I am facing performance issues with the query. Since I am
> executing this complex query twice, once to get the
eving the no of records using the
> following query and then again executing another query which actually
> limits the no of records to 20. I am facing performance issues with
> the query. Since I am executing this complex query twice, once to get
> the records and another time to get t
Hi,
I have implemented pagination for the search functionality in my
application. Since I have a lot of data, I thought in memory paging
would not be a good option and opted for paging at the database layer.
To do this I am retrieving the no of records using the following query
and then again
