topic 150 columns in one table...... in QlikView

150 columns in one table......

Tue, 26 Jul 2011 03:25:54 GMT

is there any drawback in designing a dashboard that include one transactional table with 150 columns?

Tue, 26 Jul 2011 04:04:37 GMT

Hi,

Might be you will face some memory/performance issue.Do you think all 150 columns are needed

-Jai

Tue, 26 Jul 2011 04:06:29 GMT

Yes because i concatinated all transactional tables in one table. i had to do it because of the complex table design

erichshiino — Tue, 26 Jul 2011 09:39:36 GMT

Hi,

It's easier to get performance problems with larger data volumes, but I guess it will depend on your hardware and total number of lines as well.

I would be more careful with the design of the data model and expressions.

I recommend you check these files:

Hope this helps,

Regards,

Erich

danielrozental — Tue, 26 Jul 2011 13:26:43 GMT

Jean, you could also build a link table instead of concatenating all tables. This will create smaller tables instead of just one large table.

Tue, 26 Jul 2011 16:16:46 GMT

Dear Damiel,

I could not download Doc optomization best practices the file is not opening,

could you upload it again or send it to me ?

erichshiino — Tue, 26 Jul 2011 16:29:54 GMT

I'm not sure if you will be able to download mine since you had problems with the first one, but let's try

Tue, 26 Jul 2011 17:45:57 GMT

thanks it worked