Hi all,
I need some suggestion on a mapping that i have been doing for injecting the data into the back end.
The process involved is as follows:
1)Say i have a request in the form of a XML :
<document>
<data>
<row index="0">
<domainid>233</domainid>
<paddr2>gdfgh</paddr2>
<form_id>newapplicant</form_id>
<mobile>34567</mobile>
<title>Mr.</title>
<firstname>Michael</firstname>
<emergency_no>911</emergency_no>
<daytime>34</daytime>
<rent_max>330</rent_max>
<rent_min>120</rent_min>
<entity_type>applicant</entity_type>
<house_type>2</house_type>
<surname>henry</surname>
<paddr1>4</paddr1>
<email>abc@mail.com</email>
<location>11</location>
<area></area>
<bedrooms>5</bedrooms>
<property_alerts>2</property_alerts>
</row>
</data>
</document>
Now after parsing the data from this XML using SAX/DOM parsers
I create a Data Structure like a +(Hashtable)+ where the tag names act as the <Keys> and the text content inside them becomes the <Values>.
I then use this Hashtable for populating the matching columns in the database. //Issue
Now as we can this process becomes a huge bottle neck over a period of time as the no of fields in the database
increase can anyone provide any suggestions on how to
handle this issue in a more optimized or generic manner.
--
thanks