>Hi,
> I have re-test the performance of local view and SQL statement and it give huge different.
>
>
>Method Time Taken
>View
>(Click browse from project manager 35-48 secs
>
>SQL Statement < 1 secs
>(Copy the SQL statement generated
>by View Designer)
>
>
>
>I close VFP each time for testing.
>
>Why it happen?
>
>Thank you
Is your SQL statement (copied from the View Designer and run from the command window or a prg) running asynchronously? (Tools | Options | Remote data tab, Asynchronous execution check box) This means that the first data begins to show while the remaining data is still coming down the wire.
Another idea: When I used the view designer against a large (many tables) database, it seemed to be querying the database for something every time I opened it. Whatever it is, this does not happen in SQL pass-through.