>Jim,
>
>I really appreciate your help. I've spent over a day of trial and error on this with no success.
>
>Here the SQL statement for my view VLOAN:
> SELECT Loan.acctno, Loan.agentstate FROM pm!loan WHERE Loan.bidavailable = .T.
>
>I've distilled the problem down to this:
>
>When I run the SQL statement form the command window, it takes .26 seconds, When I USE VLOAN from the command window, it takes 4.38 seconds, and shows me the Running Query... progress bar the whole time.
>
>I have SET DELETED OFF for both, and the same available memory and environment settings. I'm running on a Pentium 200, 32 mb, local drive. I've tried using a different database container, same results. There are 230 fields in the LOAN base table (yes, it is normalized!).
>
>Another view gives me similar results: .68 seconds for just the SQL statement, 1.13 for opening the view.
>
>Are views just inherently slower?
Darren,

What is the time for the second use of the view? IOW, if you requery() the view after you've USEd it does it go faster?