topic Re: Large Dataset Wide and Long Table Load Times Issue in App Development

Large Dataset Wide and Long Table Load Times Issue

Asuod_ — Mon, 22 Apr 2024 23:10:31 GMT

Hello,

I have a data set of 1.3 million rows. For a lot of the visuals I require a long table so when i create a long table it produces 153 million rows. The widgets have a hard time loading that much data especially when the widget is using the long table. the long table gives me what im looking for in the visuals but the widget loading is really bad, Is there any other options that has the same functionality of the long table?

Re: Large Dataset Wide and Long Table Load Times Issue

marcus_sommer — Tue, 23 Apr 2024 07:49:12 GMT

A well build data-model + UI have not mandatory a problem with 153 M of records. Please elaborate in more details how data-model + data + UI + expression are look like.

Re: Large Dataset Wide and Long Table Load Times Issue

CHRIS_Singa — Tue, 23 Apr 2024 08:00:05 GMT

Transform your data to qvd or parquet format.

It may reduce the time