Selected Columns in a Repeater with Custom Query.

Vic Carter asked on February 27, 2014 10:53

When using a Repeater with a custom Query where all returned columns are defined and the ##COLUMNS@## macro is not being used, does the "Selected Columns" property have any impact on performance? To me it seems like it wouldn't, but we recently got some suggestions for efficiency upgrades and this was one of the things mentioned.

Thank you

Recent Answers


Brenden Kehren answered on February 27, 2014 14:26

If you're already limiting your columns in your custom query then utilizing the "selected columns" property is worthless, especially if you don't have the macro in your custom query. The good thing about using the macro is you can make changes without having to modify the query.

0 votesVote for this answer Mark as a Correct answer

Richard Sustek answered on March 1, 2014 03:11

Hi,

Thank you for your message.

If you are defining all columns in your query and then bypassing the macro at all there is really not performance downside. I would even say that its more efficient as the substitution macro for selected columns doesnt need to resolve (although the gains are really, really small, but definitely not worse.)

Maybe what they meant is that you are getting more columns that you actually need so you can check that out otherwise this seems a correct approach to me.

Kind regards,

Richard Sustek

0 votesVote for this answer Mark as a Correct answer

   Please, sign in to be able to submit a new answer.