CODEWITHSUNDEEP
asp.net
user1166981
user1166981

Reputation: 1746

What code design is most efficient for working with large (relatively static) data grids?

I plan to use asp.net to show about 2 million rows of data (about 7 columns) on the main index of the site in a data grid using jquery. I only need to update the database once in a while, probably daily, so I wondered what would be the most efficient code design to reduce load if there are a large number of users (thinking there might be an efficient way to do it specifically for static data).

Upvotes: 0

Views: 84

Answers (1)

HatSoft
HatSoft

Reputation: 11201

I plan to use asp.net to show about 2 million rows of data (about 7 columns) on the main index of the site in a data grid using jquery.

Given that I don't know your domain, my suggestion would try to page it and example 1000 rows at a time because I cannot see user seeing all 2 million rows at one time

Else get only the records just required of the user, for the user, by the user

Upvotes: 1

Related Questions