Create a cached instance of a view from a linked server?

Hi
How do i manage to create a cache of a view from a linked server?
I have this view on a linked server (takes app. 15 secs) and i would like to
have a "local" cache of this view.
What would be the best way to handle this - to ensure both performance and
consistency?
Hope somebody can give me an answer to this.. :-)
Hi
Persist the data to a local table, and have a job that refreshes the table
on a regular basis.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"pnp" <pnp@.discussions.microsoft.com> wrote in message
news:ADA26A03-95C5-4737-9176-B4C114E15EA6@.microsoft.com...
> Hi
> How do i manage to create a cache of a view from a linked server?
> I have this view on a linked server (takes app. 15 secs) and i would like
> to
> have a "local" cache of this view.
> What would be the best way to handle this - to ensure both performance and
> consistency?
> Hope somebody can give me an answer to this.. :-)
|||Ok, thanks...
Thought that would be the best way - but didn't know if there were any
built-in features that allowed me to do this easier.
But thanks - i'll take this road then... :-)
"Mike Epprecht (SQL MVP)" wrote:

> Hi
> Persist the data to a local table, and have a job that refreshes the table
> on a regular basis.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "pnp" <pnp@.discussions.microsoft.com> wrote in message
> news:ADA26A03-95C5-4737-9176-B4C114E15EA6@.microsoft.com...
>
>
|||Replication is an option. But I wouldn't do it for just one table. Keep it simple.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"pnp" <pnp@.discussions.microsoft.com> wrote in message
news:4D5977DE-FB7A-4C19-8236-6E3BC3B70C8A@.microsoft.com...[vbcol=seagreen]
> Ok, thanks...
> Thought that would be the best way - but didn't know if there were any
> built-in features that allowed me to do this easier.
> But thanks - i'll take this road then... :-)
> "Mike Epprecht (SQL MVP)" wrote: