Integration

Hi,

I have a requirement to get the distinct nodes coming from DB.

Lets say we have a structure like this coming from DB

Store1 Employee1 Role1

Store1 Employee1 Role2

Store1 Employee2 Role3

Store1 Employee2 Role2

Store1 Employee2 Role4

Store1 Employee3 Role1

Store1 Employee3 Role2

.....

Store2 Employee1 Role9

Store2 and so on.....

I need to give the output in form of

<Info>

<Store>

     <Name>1</Name>

     <Employees>

           <Employee>

               <Name>

               <Role>

          </Employee>

           <Employee>

               <Name>

               <Role>

          </Employee>

     </Employees>

</Store>

How can i do it..

I was thinking of getting a distinct , i saw 1 function over internet i.e.

distinct-deep,

but that is very time consuming.

I have huge data coming from DB which is greater than 1Mb and the performance of service is getting affected because of that. Sometimes it takes more than 4minutes to process the structure in Xquery itself.

DB is taking less than 1 second to return 1Mb data.

Can you let me know how can i achieve this with performance of service not getting effected.

For data less than 10-50Kb it is taking less than 1-2 seconds.

Regards,

Jim