We're Moving to a New Support Platform – Starting June 1st!

We’re excited to let you know that starting June 1st, we’ll be transitioning to a new support system that will be available directly on our product websites – Amelia, wpDataTables, and Report Builder. In fact, the new support platform is already live for Amelia and wpDataTables, and we encourage you to reach out to us there.

You'll always be able to reach us through a widget in the bottom right corner of each website, where you can ask questions, report issues, or simply get assistance.

While we still do not offer live support, a new advanced, AI-powered assistant, trained on our documentation, use cases, and real conversations with our team, is there to help with basic to intermediate questions in no time.

We're doing our best to make this transition smooth and hassle-free. After June 1st, this current support website will redirect you to the new "Contact Us" pages on our product sites.

Thanks for your continued support and trust – we’re excited to bring you an even better support experience!

Okay
  Public Ticket #2843517
API slow
Closed

Comments

  • Dave Haner started the conversation

    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

    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.