Yan
Sun Sep 23 16:48:01 PDT 2007
Thank you both for the responses. I'm still on the learning process.
Ryan Paradela
"Dan Freeman" wrote:
> I'd be surprised if remote views were actually faster than SPT. They're
> really exactly the same, except the remote view puts a fancy GUI on the
> front of the process and issues a lot of commands that you don't have to
> type, many of which aren't strictly necessary every time through. You can
> turn on ODBC logging to actually see these commands happening.
>
> (If you're not sending updates, why set UpdateTables? Views do that, and
> more.)
>
> They're exactly the same technology.
>
> MVP Andy Kramek espouses a very metadata-driven approach to data handling
> (which I like a lot), where his own code accesses back-end data. That pretty
> much precludes remote views because the code is manufactured on the fly.
> Check it out at
http://www.tightlinecomputers.com/ -- there should be a
> white papers section.
>
> Dan
>
>
> Yan wrote:
> > I see, but which would you prefer to use. SPT calls, or using remote
> > views? I have been developing complex applications and this year we
> > just started to use SQL Server. Ever since I was employed as a
> > developer I only used VFP. So now that I have this opportunity to
> > learn SQL Server I have been wondering which would be better, in
> > terms of data retrieval and update, to use remote views or SPT calls.
> >
> > Thanks Anders!
> >
> >
> > Ryan Paradela
> >
> >
> >
> > "Anders Altberg" wrote:
> >
> >> A problem when you try and make these tests is that SQL Server, just
> >> like VFP, caches data and queries plans so that running the same
> >> query, even when switching between remote views and SPT calls, tends
> >> to run faster for each repetition.
> >> -Anders
> >>
> >> "Yan" <Yan@discussions.microsoft.com> wrote in message
> >> news:FEFFEE0F-19AC-4997-85EC-791FECB7579D@microsoft.com...
> >>> Hello!
> >>>
> >>> I'm still new with MS SQL and I tried to use the SQLEXEC() function
> >>> to execute the STORED PROCEDUREs I coded at the SQL Server but when
> >>> I tried to
> >>> use the remote views I found out that its much faster than the
> >>> SQLEXEC function.
> >>>
> >>> So I would like to ask for any suggestions about this, if the using
> >>> the remote views in updating the data at the SQL Server is much
> >>> faster compared
> >>> to using the SQLEXEC function.
> >>>
> >>> Thank you.
> >>>
> >>> Ryan Paradela
>
>
>