B
BillGatesFan
My boss wants to somehow mimic Google and return only what is displayed
in the datagrid back to the client. He guess that is what they are
doing. So each time they pick a page number it will only go back and
get the 10 results for that page.
My question is this more efficient that going on the first trip pulling
all 500 records and storing the dataview in a session variable and
manipulating it to display the results?
I say no because if the bottleneck is the database you want to limit
the times you hit it but I'm open to a discussion about this.
The disadvantage of my way is if you have a site with high volume, you
might have 1000 users with a dataview in session with 500 results and
it will take up resources.
Please help solve this debate. Thanks
in the datagrid back to the client. He guess that is what they are
doing. So each time they pick a page number it will only go back and
get the 10 results for that page.
My question is this more efficient that going on the first trip pulling
all 500 records and storing the dataview in a session variable and
manipulating it to display the results?
I say no because if the bottleneck is the database you want to limit
the times you hit it but I'm open to a discussion about this.
The disadvantage of my way is if you have a site with high volume, you
might have 1000 users with a dataview in session with 500 results and
it will take up resources.
Please help solve this debate. Thanks