Consolidate Returned Data

So I'm trying to get this data into tables:

http://census.daybreakgames.com/xml/get/ps2/character/5428010618040144225?c:resolve=weapon_stat


Problem is each stat type are all listed independently as siblings. My server has to work on stitching it back together as one weapon stat record to store it in the weapon stats table. This takes a lot of unnecessary processing time and I would like to reduce this by as much as possible.

I tried messing around with the V2 trees to combine the weapon_stat records by item_id and vehicle_id but I can't get it to work. If they were better organized it would go a lot faster.


Does anyone know what I can do?

 

Here is an example of pulling the stat_name out and making it a level int he hierarchy
http://census.daybreakgames.com/json/get/ps2/...tart:stats.weapon_stat^field:stat_name^list:1

This example extends the one above by making vehicle_id and item_id levels as well
http://census.daybreakgames.com/json/get/ps2/...hicle_id^prefix:vehicle_,item_id^prefix:item_

hope this helps.