>
>As I stated earlier I am trying to move to TSQL. I am worried that doing so may not alleviate this issue. Would it be true to say that I should optimize my views (meaning make them fast whatever that consists of) BEFORE switching to TSQL? I am NOT referring to making them faster so my users have a better experience until I get to TSQL. I mean is this something I had better do because TSQL will not work much better unless I do so.
>
I wouldn't worry about that, unless you were optimizing the views (by either adjusting the queries, or creating indexes that matched your filter parameters) just to make the app faster. That in and of itself won't really help you to optimize it in SQL Server. SQL Server has a different query engine than VFP, so they behave differently, the optimizations work differently, etc.