Hey there, Awesome Customers!

Just a heads up: We'll be taking a breather to celebrate International Workers' Day (May 1st and 2nd - Wednesday and Thursday) and Orthodox Easter from Good Friday (May 3rd) through Easter Monday (May 6th). So, from May 1st to May 6th, our team will be off enjoying some well-deserved downtime.

During this time, our customer support will be running on a smaller crew, but don't worry! We'll still be around to help with any urgent matters, though it might take us a bit longer than usual to get back to you.

We'll be back in action at full throttle on May 7th (Tuesday), ready to tackle your questions and requests with gusto!

In the meantime, you can explore our documentation for Amelia and wpDataTables. You'll find loads of helpful resources, including articles and handy video tutorials on YouTube (Amelia's YouTube Channel and wpDataTables' YouTube Channel). These gems might just have the answers you're looking for while we're kicking back.

Thanks a bunch for your understanding and support!

Catch you on the flip side!

Warm regards,

TMS

Okay
  Public Ticket #2843517
API slow
Closed

Comments

  • Dave Haner started the conversation
    August 6, 2021 at 5:10pm

    I am trying to use google sheets and api to populate webpages.  Even though the sheets aren't that big, the api calls are taking a long time and pages are thus about 10s to load.

    Any suggestions or should I not use api?

    Thanks

  • [deleted] replied
    August 8, 2021 at 10:03am

    Hi Dave

    Thank you for reaching out to us.

    How big is the Google Spreadsheet table. These tables are non-server-side tables, which means that the entire table is added to the page using JavaScript, instead of being split per pages (currently visible rows), so if the table is big, it will become slower and slower, until it eventually breaks (no defined limit, as it depends on the server's performance, hosting plan, etc, but 2.000 - 3.000 rows is considered as a big table).

    There's nothing in the plugin that would speed it up, as it's already minimized to the max. The API method should be pretty fast, if you have shared hosting you will have to switch to dedicated hosting.