>Is there any method of changing the way remote views are recreated? Currently when recreating remote views, each view seems to be generating an SQL command of "SELECT * FROM table" which on large tables and on a WAN can take a long time (several minutes).The idea behind a Client/Server architecture (and hence Remote Views) is not to query the whole table (
SELECT * FROM Table
) but only bring a subset through the wire (especially in a WAN). With RVs you do that through parameters (parameterized views). Something like:
SELECT * FROM Table WHERE City = ?cCity
. If you initialize:
cCity="Granville"
before a Requery() then you only get the matching records.