i have 6 documents and i want to extract the data from all these 5 tables and make an xml document. please help me how i can achieve this. each document contains more than 100000 records. actually the data is mapped from sql database using xnode.
now i have 2 things in consideration
- if i join all these 6 tables, how will be the performance
2.how i can join these tables