Best Practices Report Detail Page

[Elena]

Hi all,

 

Anybody has any advise on best practices in building details page in reports?

Somehow I managed to make my details pages in my report to "crawl" and move slower than molasses. I know it's because of the big amount of conditional calculations and charts that I have in the details page.

 

Do you have any good piece of advise to give in terms of using calculations, virtual fields, and parameters?

 

In particular: 

 

1. Should I use more virtual fields (with data source as the calculated fields) and have the calculated fields hidden?

 

2. Should I limit conditional calculations and use more scripts instead?

 

My page sure is slow.

 

Any ideas will be greatly appreciated.

 

Best regards,

Elena

 

[Elena]

oh another relevant question. Do spaces in between conditional strings affect the speed in which the details page is executed and shown?

[Jan]

Hi Elena,

 

Can I ask several additional questions?

Could you provide the URL of your DataPage?

Do you use URL or Embedded deployment?

[Aether]

Hi @Elena,

What I suggest for you to lessen the slowness of your page is:

- limit the use of List- strings, drop-downs, images, and other fields that will load multiple data or large amount of file size.

- Also limit the script code that you use.

I think the calculation, virtual fields and parameters won't take affect the slowness of your page.

~WatashiwaJin~  

[TsiBiRu]

Hi @Elena,

For more details about the best practices in creating your DataPages/Application, kindly see the link below. 

https://howto.caspio.com/datapages/best-practices-in-creating-caspio-applications/

I hope this helps.

Regards.

TsiBiRu