>Very disappointed in the performance of SQL Views, feel I should have stayed with the procedural code in FP2.6 which ran just fine. However, we've made the leap and now must find out why Local Views, OR Remote Views perform as if we're back in DbaseIII.
>
>The P120 box now has 64mb RAM total. Slight improvement only. SQL Select statement is simple, no joins, One table of 500k rows. Other Views on smaller tables run OK, so I'm thinking that Rushmore is not kicking in properly, the SQL Select is not being optimized by VFP, however it's a direct query on Primary Key - parameterized, but nothing fancy in the short query string. Tables have been reindexed.
>
>Response is very slow on a Local view, (10 tables open)... And even worse on the same table upsized to MSSQL. The same SELECT works just fine from ISQL command window direct in SQL Server. Now I know why I never used SQL much in VFP, when SEEK WHILE is 10 times faster... any ideas?


Hi Brian,

The idea behind designing Remote Views is to empower VFP with Client/Server
functionality. If you are developing C/S application, you have to be very
careful about retriving record set from the remote table. You have said that
you are just retrieving 500 records without any Joins. The statagy of
SELECT * is not advisable for C/S application. You have to minimize the size of a record set to reduce network traffic and get best retrieval speed.

SELECT * FROM .. will surely slow down the speed. Alternatively you can set it
as Fetch As Needed to make VFP load the data independtly.

Hope will help

Bye
Jayesh