I am new to Asp.net development, currently I am working on a web project using asp.net and Vb.net.
Temp table with 20 lac records with 30 columns approx.
userid int autoincrement
Allocate 1 to thousand records to user and then view these records one by one and update some. And again save to Database. Likewise another user can be allocate with 1001 to 2000 records. Database uses MySQL.
Approx 2000 concurrent users are going to access this site, and each user has set of records explained above.
Select required fields in Dataset
Manipulate data one by one from dataset and display on screen.
Store updated record database.
Keep track of updated records with flags in Database table
Navigation of records using previous and next buttons.
How to store data in Dataset for each user.
How to maintain performance for each user for accessing data.
Maintain concurrency in users.
Application server and Database server are separate.
Please suggest best approach to start with.
asp.net mysql vb.net