Looping over thousands of records to pass over a webservice is probably going to be slow anyway, isn't it?
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 was going to quote Joe Rinehart on doing this kind of stuff, but I think you'd be better of reading it yourself. http://webservices.sys-con.com/read/47199.htm - Matt Small; -----Original Message----- From: Bryan Stevenson [mailto:[EMAIL PROTECTED] Sent: Friday, November 04, 2005 11:50 AM To: CF-Talk Subject: Re: CF webservice consumed via .NET > I *think* if you were to create a .NET object that mirrors the structure > of > the query object, .NET would probably be able to use the query type > returned > from CF. > > However, it would probably be easiest to serialize the output of the query > into an XML string and just pass it via the webservice as a string, which > could easily be read by .NET. > > - Matt Small Thanks Matt... I'm trying to avoid looping over the query to convert it to an XML string....when you return thousands of records it sure slows down the service ;-) I'll do it if I have to though. Anybody else have 2 cents to add....I know you're out there and I know you've bumped into this....where's Barney B. and Dave W.?? ;-) How about structures returned from CF web services....does .NET choke on those as well? TIA Cheers 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 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:223234 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
