Better Performance
Posted: Fri Mar 07, 2008 4:10 am
Hi Everyone,
I have a design issue.
In the source DRS I need to get data from 28 tables.The structure of the tables are same but having very huge amount of data. (all the rows are distinct)
I would kindly like to know which one will give me a better performance
My options are
1.Using a UNION in the source DRS
2.Using a UNION ALL in the source DRS
3.Using 28 sepreate DRS in the source and using LINK COLLECTOR to combine the data.
I thought it would be the UNION ALL since it merges data from the Database itself but
I read in one of the DSxchange post that its LINK COLLECTOR which will give a better performance than UNION ALL
viewtopic.php?t=113306&highlight=Link+Collector
(please refer to the post from balasumit21 )
Please advise
Thanks
George Sebastian
![Wink :wink:](./images/smilies/icon_wink.gif)
I have a design issue.
In the source DRS I need to get data from 28 tables.The structure of the tables are same but having very huge amount of data. (all the rows are distinct)
I would kindly like to know which one will give me a better performance
My options are
1.Using a UNION in the source DRS
2.Using a UNION ALL in the source DRS
3.Using 28 sepreate DRS in the source and using LINK COLLECTOR to combine the data.
I thought it would be the UNION ALL since it merges data from the Database itself but
I read in one of the DSxchange post that its LINK COLLECTOR which will give a better performance than UNION ALL
viewtopic.php?t=113306&highlight=Link+Collector
(please refer to the post from balasumit21 )
Please advise
Thanks
George Sebastian
![Wink :wink:](./images/smilies/icon_wink.gif)