Jump to content
  • 0

Slow loading of forms


KG360

Question

I have several forms with a lot of calculations. When the user loads the form, all formulas seem to kick in, and all fields retrieve data, even for sections that are not yet visible to the users. This makes the forms load slowly, to the point a user believes there is something wrong.

Is there an easy way to fix this?

/KG

Link to comment
Share on other sites

7 answers to this question

Recommended Posts

  • 0
On 5/17/2023 at 12:34 AM, Aether said:

Hello @KG360 - What I can suggest is for you to partition your form and separate them on a different submission to create a "Multi-step form" so that the loading the page won't be that heavy to load. Refer to the article below:

https://howto.caspio.com/tech-tips-and-articles/how-to-create-a-multi-page-form/

 

Thank you! I am aware of the possibility, but I am scrambling to handle everything with 50 DataPages so I am reluctant to use multistep forms, but I might have to in the end. I also have a lot of drop downs and choices and a lot of text that need to load, so it is not entirely unexpected. However, I thought I could at least block calculation and search to occur before some sections are loaded...

Will ponder some more on what to do...

Link to comment
Share on other sites

  • 0
On 5/17/2023 at 12:58 AM, Aether said:

You may want to check this cause of slowness as well:

 

 

Thanks, and got that! There is nothing in this thread I have not considered or implemented. 

Link to comment
Share on other sites

  • 0

Did you find an answer? I'm also so close to the 50 page limit for my plan that I've put way too much into a single page. But I did find that I had taken the wrong approach with my views. 

I created a very simple datapage table - with a results page and it took 3-4 minutes just to preview the page. If I passed a parameter and went straight to the results page, it was about 30 sec to 45 secs. The issue turned out to be the size of view. I'd been using the same view for multiple pages, and the views over time were getting bigger and bigger - so even pages that once were quick, became slower!

Now I need to go back and make more views for my pages and retest/change the pages as required to keep everything as lean as possible. I'm also creating a separate calc table for my user data to push as much calculation off the page load and into the tables as I can.

If you found other options that worked, it'd be great to hear.

Link to comment
Share on other sites

  • 0
On 5/26/2023 at 8:00 AM, Jodie said:

Did you find an answer? I'm also so close to the 50 page limit for my plan that I've put way too much into a single page. But I did find that I had taken the wrong approach with my views. 

I created a very simple datapage table - with a results page and it took 3-4 minutes just to preview the page. If I passed a parameter and went straight to the results page, it was about 30 sec to 45 secs. The issue turned out to be the size of view. I'd been using the same view for multiple pages, and the views over time were getting bigger and bigger - so even pages that once were quick, became slower!

Now I need to go back and make more views for my pages and retest/change the pages as required to keep everything as lean as possible. I'm also creating a separate calc table for my user data to push as much calculation off the page load and into the tables as I can.

If you found other options that worked, it'd be great to hear.

Nice reasoning, thanks! I agree about views. I have been lazy and included all fields even if I use only 10%. The view are extremely large and take too long time to load. It is on my list to, once I am ready developing, to take ti e out and list all non-used fields in all views. I will ponder on the passing of parameters. I too, have move many calculations into the tables, but still need DataPage formulas in reports to recalculate things real time for the user to see.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
×
×
  • Create New...