Where to store search result

[vuthaianh]

I'm creating a searching functionality of my project. When the result including many records is returned, i want to do paging with the result so where should i store the result to do that, in the session, viewstate or in the database. Actually, instead of storing the result of search, i store the searching query in the wiewstate and each time a user clicks next page button, i execute the searching query from the viewstate with new page index. Thanks