Forum Discussion

dilkushpatel's avatar
dilkushpatel
Icon for Helper III rankHelper III
10 years ago

Performance issue with Direct Query with SQL Azure

Hi, I'm trying to use direct query feature with data from SQL Azure DB. Now I do have quite a good amount of data in there . (one of the fact has 7 mil records)   I understand that with qirect qu...
Need Help
Show and Tell
Tips and Tricks
andre's avatar
andre
Icon for Memorable Member rankMemorable Member
10 years ago

there are three things you can do:

  1. create an index and see if that helps
  2. bump up the performance characteristics of your Azure SQL Database
  3. explore in-memory option for your database

7M rows is not a large dataset and if your tables are not very wide, I would also explore importing the entire data set into your model, my guess you will see good compression with that and it might be below the 250mb limit

  • dilkushpatel's avatar
    dilkushpatel
    Icon for Helper III rankHelper III
    10 years ago

    Hi,

    By In-memory option for database you mean importing in pbix or SQL Azure has some setting for this?

    Actiually there are 3 tables with approx 7 mil each and then there are 5 dimension tables.

     

    I will try importing in pbix and see how it goes.

     

    Thanks,

    Dilkush

    • andre's avatar
      andre
      Icon for Memorable Member rankMemorable Member
      10 years ago

      yes, in Azure SQL you can create in memory indexes which can potentially improve performance.