I have problem in asp.net page process

Posted by Nuwan under ASP.NET on 5/31/2012 | Points: 10 | Views : 752 | Status : [Member] | Replies : 2
Dear All,

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.

Rathnayake


Responses

Posted by: Ashoknalam on: 6/1/2012 [Member] Starter | Points: 25

Up
0
Down
Could you please explain your query in detail.

Ashok Nalam

Nuwan, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Ajay.Kalol on: 6/2/2012 [Member] Starter | Points: 25

Up
0
Down
That's depends on your query you have written. and Code you have written for retrieve.

if you want any solution for this then put your table details and conditions for get Data.

By which one can design simple and fast query as per his/her best knowledge for you.

Enjoy...

Ajay
ajaypatelfromsanthal.blogspot.in

Nuwan, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response