We created Asp.net Application for our finance company with Sql Server . it database have more than 30 table.it one of process we read 10 of table in that database
and get that value in variable and insert that value in new table, It table have 30 column and insert 4000 of data in that table.
But problem is that process is very slow. going to 2hours of that process. How I Speedup that process.
Please help me that matter.