General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
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.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only