You need to use a paramaterized view. Client server networks are designed
to return a small subset of data, not the entire table contents. If you
have a paramerized view set up to use a primary key you should be returning
a single row. Since a PK uses an index, the response time will be much
better than pulling down the entire table (sub second versus 30 mintues).

Even in the case of using a foreign key returning say a 1,000 rows (again
assuming the column is indexed) the respons time should not take more than 2 seconds.

>I setup a remote view on an SQL database (on our local 100 base T network.
>
>Then I click on the view in the DBC and i apparently loads the entire table. There are over a million records and the odometer on the botom just slowl; moves up the record count, but I can no do anything but wait until it finishes.
>
>I guess the answer is do not try to view the data from there.