Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

jt0803aa
New Contributor

GROUP BY PERFORMANCE

HI

I HAVE A VERY BIG TABLE 500 FIELDS 40M ROWS TRYING TO GROUP THIS TABLE AND IT TAKES FOREVER AROUND 8HRS

ANY IDEAS HOW TO IMPROVE THIS GROUP BY???

TRIED TO CUT THIS TABLE TO 5 SEPARATE TABLES  THAT HAVE 100 FIELDS AND 40M ROWS AND THEN JOIN BACK ALL 5 TABLES BACK TO ONE THIS DIDN'T IMPROVE THE PERFORMANCE BY MUCH

ANY OTHER IDEAS?

THANKS

JT

1 Reply
vikasmahajan
Honored Contributor III

Re: GROUP BY PERFORMANCE

can you post script and purpose of joining tables ?

Vikas

Community Browser