How to Increase Performance in my Database for 40000 Records

Dec 18 2016 8:56 AM

In My sql server table There is a 40000 records and i use the FOR LOOP(Looping) for 40000 Records There is a 7 FOR LOOPS inside main FOR LOOP so it take much time when i executing the query in my aspx page on submit button to check the all the records...

How Increase perfomacne give me some suggestion

Answers (2)

Multi level sorting for single filed in xsl in asp

Object reference not set to an instance of an object(???)