This is a migrated thread and some comments may be shown as answers.

Optimalization of GridDropDownColumn

8 Answers 90 Views
Grid
This is a migrated thread and some comments may be shown as answers.
staron
Top achievements
Rank 1
staron asked on 07 Jan 2009, 11:21 AM
Hi,
We are wondering if you had some best practice examples on how to configure the GridDropDownColumn. (Which properties to etc) We are having some problems in that it is querying db for data even when it's not in editmode.

8 Answers, 1 is accepted

Sort by
0
Shinu
Top achievements
Rank 2
answered on 08 Jan 2009, 06:01 AM
Hi Staron,

Please refer following link to online documentation. I hope this will help you in configuring "GridDropDownColumn".
Customize/Configure GridDropDownColumn

Thanks,
Shinu.
0
staron
Top achievements
Rank 1
answered on 08 Jan 2009, 09:05 AM
Hi,
Thanks for your reply. I have read this prior to my post, but it does not say anything about our main issue. Namely that the column queries the db on load, and then again when you enter edit mode. Is there a way to prevent this?
0
staron
Top achievements
Rank 1
answered on 08 Jan 2009, 11:15 AM
Done a bit more research and the dropdowncolumn does one query for each grid row also. This is unacceptible as this will kill performance on large grids.
0
Sebastian
Telerik team
answered on 08 Jan 2009, 11:26 AM
Hi staron,

Indeed if you have very large number of items in the dropdown editor, this may cause a performance penalty when using built-in GridDropDownColumn. In such cases you may consider placing RadComboBox inside template grid column and utilize its load on demand mechanism as shown in the example from the knowledge base article linked below:

http://www.telerik.com/support/kb/aspnet-ajax/combobox/using-radcombobox-with-autocomplete-as-a-custom-editor-in-radgrid.aspx

Best regards,
Sebastian
the Telerik team

Check out Telerik Trainer, the state of the art learning tool for Telerik products.
0
staron
Top achievements
Rank 1
answered on 08 Jan 2009, 12:52 PM
Hi,
This doesn't really solve my issue. Take this scenario. My grid has 10 rows, when grid is loading its data, it first gets these 10 rows from db. Then it makes one call for each row to the combobox datasource. Thus it makes 11 db calls just to load!
I need a way to prevent the combobox from making a db call until its data is actually needed, when it goes into editmode...

Hope you can help as this is rather urgent.
0
Sebastian
Telerik team
answered on 08 Jan 2009, 01:03 PM
Hello staron,

In the sample project from the kb article the items in the comboboxes should be generated on demand only when you start typing in it or open the dropdown. Let me know if I am missing something obvious.

Best regards,
Sebastian
the Telerik team

Check out Telerik Trainer, the state of the art learning tool for Telerik products.
0
staron
Top achievements
Rank 1
answered on 08 Jan 2009, 01:16 PM
I appologize, I was a bit hasty there. I got it working now, thank you. Is there any plans on adding the loadondemand property to the dropdown column in the future?
0
Rosen
Telerik team
answered on 09 Jan 2009, 02:25 PM
Hi staron,

Thank you for your suggestion. I will forward your request to our development department for further consideration. If this appears to be a common request and an attainable enhancement, you may see it included in a future version of the product

Best regards,
Rosen
the Telerik team

Check out Telerik Trainer, the state of the art learning tool for Telerik products.
Tags
Grid
Asked by
staron
Top achievements
Rank 1
Answers by
Shinu
Top achievements
Rank 2
staron
Top achievements
Rank 1
Sebastian
Telerik team
Rosen
Telerik team
Share this question
or