Field value Length causing performance issue in table

MEDHA07 — Fri, 17 Jun 2022 05:54:55 GMT

Hi All,

One of my app has size around 6gb for 3 years of data.I used two tables to load the data from source .

One table has unique records and second table has duplicate records. In data model created One to Many relationship.

In UI we are using only a straight table loading all fields which are coming from the source. No calculated measure fields.

The detailed table has 36 crs of data and Unique table has 10 crs of data.

even the qvd size for detailed for each year 5 gb and 2 gb for unique table.

I have noticed one field has characters which has max length 600 .when i check for >200 char length found records for 65 M recs.

This is the main field where you search query regularly.is there any way to optimize this field.

There is SQN id for primary key for both the tables.

Tried below:

1.Comment unused fields.

2.Checked for filters to load the data from DB.

Extraction:

Implemented incremental load already based on max date.No issues for reload.Ony facing issue at UI level that to causing performance for summary table.

topic Field value Length causing performance issue in table in App Development

Field value Length causing performance issue in table