I have a list which has more than 5000 records,it has 45 fields which includes some 12 lookup fields. I have used this list to display records using webparts and also used to display records in custom web pages.
The retrieval of the records has become slow now, initially i have paged and got some improvement, but again after a month the display has become slow now.
How do i work out on this performance issue. I get close to 750 records per month.
Please give me some tips to tackle the performance issue.
View Complete Post