Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a table with 1 million records. The table takes a lot of time to refresh. The main reason is the table has a field with hyper link. Does anyone know how to improve the refresh time on this?
What do you mean by "refresh"? Why do you suspect the field containing hyper links to be the case? What do you mean by "hyper link", simply string field containing a URL in each row?
Yes. Hyper link meaning the field containing a URL in each row. Refresh meaning the load time of that sheet. But the lag happens only the first time opening the table after the app load, subsequent openings do not have that lag.
And that does not happen when the URL field is not in the table? Have you tried using a calc. condition to show the table once one or more selections have been made by the user?
yes. that happens when the URL field is there in the table. Already have a default bookmark in the dashboard, but still bringing around 500k records. there are other dashboards with 600k records that loads much faster but they don't have URL field in it.
How long is that URL field? Are you using so users can use it a as a link? If so, try only showing a text and then add that URL as a link w/o displaying its actual value.
Yes, They can use it as a link , click here and go to the corresponding page. Already show showing it as text like below, EMP in each row, when they click it will get to the the details of that employee.
https://www.google.com || EMPID|| 'EMPLOYE' as EMP
Sorry, can't really say what might be causing this w/o seeing the data or the actual app.
why would you want to render 1m rows in a table chart at all?
best way is to limit the number of rows being rendered using a calculation condition by having mandatory selections to filter the data
Unfortunately the requirement is like that to display detailed data in a table. If a bookmark is applied, will it be considered as a mandatory selection? And also after a refresh, would the first load take more time than the subsequent ones?