> Looping over thousands of records to pass over a webservice is probably > going to be slow anyway, isn't it?
If you have to pass the result as an XML string....then yes the above is true and why I'm asking for alternative solutions (like why the hell can't CF return something useful to languages other than CF) ;-) > > I ran into this exact same situation - I serialized about 14000 records > returned from the DB into XML to pass to a .NET webservice. It took > forever > to process. I was never sure whether it was the fact that I was > serializing > it, or the fact that I was passing 14000 records across the network to a > webservice to process. Perhaps you could send each row, one at a time? > Might that be faster than serialization/deserialization? I'm curious what you mean by "serialized"? are you using a function to do this (if so it's looping anyways)? or looping and converting each row to XML? BTW..in my tests...the conversion of a query to an XML string was 100% the cause of major slow down (like 5 times slower than just returning the query) Thans Matt Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: [EMAIL PROTECTED] web: www.electricedgesystems.com ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223235 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
