You probably don't have a lot of data in SQL. But, if you are pulling all records down, ala Select x,y,z from a, sans a where clause, you are going to run into problems. Also, if your network has peak-load times, even for a small amount of data, you may still run into performance problems...

>We are currently indexing on the fly in several areas and the performance is still acceptable, I'm just worried that it will degrade over time as data is added to the SQL database.
>
>Thanks for the other suggestions, we will probably work more with the parameterized views.
>
>Doug