Selected Columns in a Repeater with Custom Query.

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.

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