I need to dump query into XML format but not in format cfwddx offer by default, but in "as is" format - one row = one element:
<row>
<column name="1"/>
<column name="2"/>
<column name="3"/>
<column name="4"/>
</row>
etc...
I made a custom tag to this job but performance is disaster. MSSQL server dump query result in a second (actually milisecond) for 8 columns and 126 rows, but my CF needs ~10 seconds (!) to reformat it in desired XML format and output it as JS variable. Of course, there are a lot other processing and logic operation that CF must do before it just dump a code, what is a real reason why I'am not using wddx to serialize query to JS or XML. I see this method "as more flexible".
Finally,my question is:
Is it better to do using lists, to dump query columns to lists (valuelist())and then to loop through, or to continue with a method I am using and, in that case, am I missing something. Do you have any idea or sugestion?
Regards,
Marko Simic
