150 columns in one table......

Report Inappropriate Content · ‎2011-07-25

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

Report Inappropriate Content · ‎2011-07-26

Hi,

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

-Jai

Report Inappropriate Content · ‎2011-07-26

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

erichshiino · ‎2011-07-26

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 · ‎2011-07-26

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

Report Inappropriate Content · ‎2011-07-26

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 · ‎2011-07-26

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

Report Inappropriate Content · ‎2011-07-26

thanks it worked