set a minimum for threadpool size
left joins instead of cross joins
lazy loading everywhere