Last post Jan 27, 2009 12:15 PM by ricka6
Jan 27, 2009 08:21 AM|Pozz4ever|LINK
in my db i've got a table, let's call it "table A" with more than 10.000 records, and a fk that link this table with one other, let's call it "table B".
the problem is that: when i want to see the List page of the table B, it takes a very long time to load it, and i think that the problem is referred to the dimension of the table A and how table B generates the FilterRepeater drop down list referred to A.
is there a nice way to solve this problem?
Jan 27, 2009 09:29 AM|sjnaughton|LINK
This is because of the ForeignKey relationship there will be a filter on the List page if you click it will show all 10,000 records what you want is some way of limiting this list a good example is the extended filtering demon strated in the Dynamic Data
Preview 2 and the Futures sample you are looking for the AutoComplete filter and it's implementation. Have a look at this article on my blog here:
This series steps through getting the Futures sampel working in your site (Note you should use the Futures sample now included in the Dynamic Data Preview 2 download here:
ASP.NET Dynamic Data 4.0 Preview 2 Samples
Jan 27, 2009 12:15 PM|ricka6|LINK
You should first annotate your partial class with ScaffoldColumn(false) on the FK field. If that solves the perf problem look at
Tweaking the Filter Repeater