It may have to do with the syntax of your SQL Code generating the views. Some SQL Commands force a complete roll through causing SQL Server to look at each row regardless of whether you want that row or not. Where I would start would be to verify the speed of your SQL Code.

Regards

J. Tryon