Forum Discussion
Helper IDesktop efficiancy in modelling
MrPatrick I am assuming you are pulling the data via direct query? do you just select the whole table or do you tye in your own sql statement
You can adust your sql statement which you can modify and select only pulling a smaller subset of rows until you have done everything you need to. (ie select top 100 * from table)
also if you can be sure to put a no lock on if the data is static, if you the data is updating, that is probably not advised
Community ChampionMrPatrick I am assuming you are pulling the data via direct query? do you just select the whole table or do you tye in your own sql statement
You can adust your sql statement which you can modify and select only pulling a smaller subset of rows until you have done everything you need to. (ie select top 100 * from table)
also if you can be sure to put a no lock on if the data is static, if you the data is updating, that is probably not advised
MrPatrickThank you for this, you were correct, I'm using directQuery and applying a SQL statement at the beginning of hte modelling process is vastly more efficient. I'd sat an thought that it'd have been useful to be able to apply a filter at load but not thought to actually look up if it was possible, turns out I should have done.
I'll go through the other answers before selecting a solution but you have helped me greatly already.