Webservice for Bulk Processing

Hi,

I have a webservice that do some processing. There are around 15,000 records to process and it takes a few minutes to finish processing due to the large number of records. Is there anyway to speed up the invoking of the webservice?

//The following loop record by record and pass each record into the webservice for processing. 

for(int i=0; i<15000; i++){

//Invoke webservice here 

} 

 

Best Regards

qing02051981 

How about writing a new web service, passing the data en bloc, letting it do the looping and processing within, instead of your client code? Either way, working on 15000 records will still take time, but you limit it to a single HTTP call (supposing the entire size of data doesn't exceed the web server's limit) instead of 15000 times.

hmm...Kind of a good idea. I will try it out. 

Thanks

just a wild guess, you mentioned about 15000 records, are you going to hit db for that number of times

if yes, that would be a not so good idea!!! if i was to do something i would use SQL-CLR integeration feature, pass datatable to sql using webservice or even directly in case just for testing.

thanks,

satish.