I am writing a cost itemization and amortization illustration program for a mortgage company.
- Thousands of loans illustrated each month
- 5-10 scenarios per loan
- Each scenario 20-50 related line items of up front cost
- Each scenario multiple amortization loops with logic for each iteration of the loop
This needs to be fast, but this could get massive, fast.
At what number of related records do I get in trouble, speed wise?