Speeding Up Reports And Other Big Domain Object Queries - Concurrent Queries

This was an interesting pattern for speeding up object population times when there are a lot of sequential queries being used.

The idea is to use threading and run the queries concurrently. The object then waits for all queries that can be performed concurrently to complete. The option of a thread pool for the database connection queries is also introduced.

Obviously going to these lengths to improve query performance should only be used when you have profiled your application and found areas that need speeding up, otherwise this design pattern is going to be overkill.

This design pattern was found at Concurrent Queries Design Pattern