11 Replies Latest reply: Nov 16, 2015 6:08 AM by Tamil Nagaraj RSS

    Making the application faster

    Nihal Cakir

      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