Making the application faster

[nigel987]

Hi,

I had a data model consisting of the table 'Anzeigen'. This table mostly contained IDs (numeric values) e.g. SourceID or AdStatus. The description of those IDs (characters) was stored in the linked tables Source and AdStatus. There is a image of the relevant part of the data model attached.

I heard that the application performance can be improved by reducing the number of linked tables. So I created QVDs which now contain a table 'Anzeigen' with the columns SourceDescription, AreaID, AdType, AdStatusDescription, ... (hence I replaced the numeric field SourceID by the character field SourceDescription, and AdStatus by AdStatusDescription).

The result of this test was:

• The generatin of the QVDs takes longer
• The application size is bigger
• The application is not faster at all. I would say that performance has remained stable

My question is: Was the assumption wrong, that application performance can be improved by reducing the number of linked tables?

Many thanks in advance for every comment.

Kind Regards

[nigel987]

HI Tamil,

will the reload be faster or will the application (refreshing of objects when chanfing filters) be faster?

[tamilarasu]

Hi Nihal,

               Mapping load is related to background loading of the data. I guess you are using left join, Since you are mentioning that the QVD generation is slow. There are many factors that affect the performance of charts. Replace If statement with set analysis for expressions. You should read the below thread. 

*** 6 Weeks in to QV Development, 30 Million Records QV Document and Help Needed!!! ****