The view is huge, but the data wanted is large subset that has parameters. It even happens when I try and create a new view and add the one table(Orders table that is huge).