Forum Discussion

MrPatrick's avatar
MrPatrick
Icon for Helper I rankHelper I
6 years ago
Solved

Desktop efficiancy in modelling

In my model is a table loaded from a SQL database, in my model the table is transformed and filtered to 10 coloumns and ~180000 rows. The source table is ~7 million rows and 25 columns and is at a re...
Tips and Tricks
  • vanessafvg's avatar
    vanessafvg
    6 years ago

    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