Performance Issue

[#1]

Hello all,

I am facing an issue with UI performance and response time.

My data model

Table 1

CustomerID ,

Brand,

Status,

Quantity,

----

---

---

Other dimensions.

Table 2

Order ID

CustomerID

Location

Delivered

....

...

Now i am using bar charts and accumulation with count distinct CustomerID   as  expression.

In order to enhance the performance am trying to implement sum() but not seeing any concrete way as CustomeID have one to many relation with OrderID.

Any Idea.

[sujeetsingh · Accepted solution]

Follow this document

Best Practices for Data Modelling

[maleksafa]

can you share some more information? like the schema and the qvw size.

[#4]

40 MB file size

[maleksafa]

40MB size is nothing big, can you upload the document or show us the schema?

[#6]

The performace issue  you facing, have you directly queried your datasource if there is any issue.

If that is fine, would there be any issue with connectivity, just check with one table.

try to use just table box, pulling all your field, if there is performance bottleneck as well.

40 MB is very small data size, just try to explore all situations.

Thanks!

[#7]

Ok

[#8]

Thanks you all for your replies.