table object getting refreshed for no reason

[#1]

Hi,

          In a particular tab I have 2 table objects, one of the table objects get refreshed just for any thing I do in that tab. For instance if I minimize the other object, or do some change in the expression or anything. Or if I add new object , delete new object... this particular table object get refreshed everything.

Also, it takes hell lot of time to display the data. This issue I am getting in development environment only...i.e in qlikview desktop, but on production it works fine.

Thanks,

Lax

[Sokkorn]

Hi Lax,

Check NOW() function whether it used with your table object or not.

Regards,

Sokkorn

[#3]

Hi,

          Not using any NOW() function. It refreshes whenever I touch other objects in that tab

Thanks

Lax

[Sokkorn]

Hi Lax,

Can you share your app?

Regards,

Sokkorn

[deepakk]

Hi Lax,

Its always better to use a pivot or straight table instead of a table box. The performance is always much better than table box.

Deepak

[#6]

Hi ,

     I can share the data model..the main table is having around 2.7 million records and others are mostly master with hardly any data into them,

My dev. environment has become very slow, inspite of having 32 GB memory and 24 CPU. The size of the application/document is 456 MB.

Please do suggest, how can I improve the performance.

Thanks

Lax

[#7]

Here is it, Also this main table is having 75 fields.

[deepakk]

hi Lax,

From the main table remove the fields which are not required in the application. As per my understanding in a an application you don't require all the field.

Also there is a linking issue. You can't link BankMaster Table with Qlikview_Data table with so many fields.

Check for the relation between this two tables. It might be only with one or two fields.

If you carry out this two activites your QV application performance will improve.

Deepak