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.