Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
615
igcombo Performance with a Large Data Set (MVC)
posted

Hello,

I'm trying to wrap my head around the performance considerations for using large data sets with the igcombo.  To provide a little context, here's my relevant View code:

@(Html.Infragistics().ComboFor(model => Model.BrandName)
                    .DataSourceUrl(Url.Action("BrandAutocomplete"))
                    .Width("24%")
                    .HtmlAttributes(new System.Collections.Generic.Dictionary<string, object>() { { "class", "col-md-6 item-search-input" } })
                    .ValueKey("BrandId")
                    .TextKey("BrandName")
                    .ShowDropDownButton(false)
                    .FilteringType(ComboFilteringType.Remote)
                    .FilterExprUrlKey("filter")
                    .FilteringCondition("contains")
                    .RenderMatchItemsCondition(ComboRenderMatchItemsCondition.Contains)
                    .DataBind()
                    .Render()
                )

The problem is that approximately 35,000 results will be returned from the BrandAutocomplete action.  This makes the combo box completely unusable since each letter typed results in a "contains" search of 35,000 records.

Of course, the problem is not really with the igcombo itself, but with my particular business case.  However, I was wondering if anyone else has needed to use igcombo with a large data set, and if so, are there any ways that I can work with igcombo to make the control feel more usable?  Am I trying to force a control to do something that it isn't really designed to do?  Are there perhaps ways that I can structure my controller action to query the database more efficiently (my ORM is Entity Framework 6)?

Thanks in advance for any advice you have!

Parents Reply Children