Here is the scenario: I have a dll which has method that gets data from db, depending on parameters passed, does various checks and gives me required data.
In a windows application, I have listbox which list 500 + agencies. I retrieve GOS for each agency append to a generic list. If the user has selected all agencies (500 + for now), it takes about 10 min. to return data from the dll.
We though about background processing. But that doesn't reduce the time, other than user get to do other things on the screen. Considering multithreading or parallel class.
Can anybody help me with this? What would be right approach and how can we accomplish this?