I am creating a feature which will allow users to import data of excel sheet to database.
First, data will be imported from excel sheet and will be displayed in a tabular format.
User performs a mapping porcess for database fields and click Submit button.
Then a stored procedure inserts all the data of each row into more than 15 tables.
Above mentioned process might cause an issue if users import more than 1000 records (they are definitely going to do that. Thats why this entire functionality is intended for).
Basically, what I would like to do is, Insert all the rows to a single table (Temp table), have a cloumn in a table which will be a flag and initially, will be set to "Pending".
Create a page which will be executed when there are less users accessing the system (Specific time),
This page will see if there are records in a temp table with FLAG "Pending". If yes then it will fetch one record from the table and will insert data of first row into all the necessary tables. After first transaction it will wait for some time and will fetch the second record....This will last until the final row of temp table is reached.
Now, my main concern is that, HOW CAN I SET A TIMER FOR ASP, ASPX PAGE TO EXECUTE IT AT A SPECIFIC TIME PERIOD.
Thanks....!