i have to search data from a database containing 2 million records. i get timeout error while using order by statement
(in order to paging using top *)
pls sugest me any new methods.....