Comments

5 comments

  • Official comment
    Avatar
    Thomas Morin

    Hello,

    Actually, it is normal that your view is long to be loaded because you have a lot of data in your spreadsheet with a lot of sheets. It also seems you have a lot of formula.

    The more you have data and formulas, the longer you view will take to load.

    Kind regards.

    Thomas

  • Avatar
    Camille Rovillain

    Hi Thomas, thanks for your reply! 

    I suppose that having a separate google sheet (each with two tabs) for each awesome table would make the loading faster than having one sheet with more tabs.

    I suppose I'll try to copy the info with Query from the tab to a new sheet and see how this improves. Thank you!

  • Avatar
    Thomas Morin

    Indeed, it is better to have an optimized sheet for one view only with the least possible formula in the Google Spreadsheet data source.

    Kind regards.

    Thomas

  • Avatar
    Camille Rovillain

    Hi Thomas,

    I used "Import range" function to move my data from a tab to a separate googlesheet and only improved speed by 1 second. Is Import range function too heavy or is it still going to the original sheet to get data?

    Any other idea?

    I'm using several AT views from the same data which is why I placed them all in the same google sheet initially so all data get synced on all AT... 

    but maybe the page speed comes from another issue... I'll have to do some research.

    Have a lovely day!

    Camille

  • Avatar
    Thomas Morin

    Hello Camille,

    Actually, it seems your view takes time to load because of your website. It seems a component of your website blocks the display of your view. 

    It could be a native script or something like that but we don't have enough information to confirm that.

    Kind regards.

    Thomas

Please sign in to leave a comment.