Subject | Re: process XML in stored procedure |
---|---|
Author | jclichthouse |
Post date | 2011-07-06T22:30:46Z |
>If your SP can parse the XML and insert the extracted info into a tempThanks for the input,
>table, then an app can also be made to parse the XML and insert the
>extracted info the same temp table. This will require multiple db calls
>(one insert per item/row), but is this really a problem? Why?
>
>Kjell
I will try to understand the way of thinking you give to me. Okay lets say that with this app the extra network traffic is no problem. To understand how you would work with this I will need to ask for some more info, this way of working is new for me.
- Is the temp table a normal table you just use to store the numbers or are you using a global temporary table?
- Lets say there a 4 users processing nummbers. How do you know what rows to use?
I ask this to get a other view on the use of this table.
Edwin