Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Martin Sellwood
  Where is Martin Sellwood?
 Maidstone, Kent
 United Kingdom
 Martin Sellwood
 To: Nilson Rishi
  Where is Nilson Rishi?
 Bangkok
 Thailand
 Nilson Rishi
 Tags
Subject: RE: performance issue with remote view
Thread ID: 104117 Message ID: 104119 # Views: 2 # Ratings: 1
Version: Visual FoxPro 9 Category: Databases, Tables and SQL Server
Date: Friday, August 11, 2006 5:07:20 PM         
   


> In forms' dataenvironment, if I use non-parameterizedremote views that will fetch all records from their base tables in SQL Server, there will be performance slow-down? Which will be better in terms of performance, those remote views or SPT?
> Regards,
> Nilson


the remote cursor is a simple wrapper for spt, so you probably wont notice a lot of difference.
however if you are pulling down a lot of records you should be using either a parameterised view or a perameterised SPT.

ENTIRE THREAD

performance issue with remote view Posted by Nilson Rishi @ 8/11/2006 4:54:12 PM
RE: performance issue with remote view Posted by Martin Sellwood @ 8/11/2006 5:07:20 PM
RE: performance issue with remote view Posted by Bernard Bout @ 8/11/2006 5:41:43 PM
RE: performance issue with remote view Posted by Nilson Rishi @ 8/11/2006 6:07:03 PM
RE: performance issue with remote view Posted by Jim Winter @ 8/11/2006 6:22:31 PM
RE: performance issue with remote view Posted by Nilson Rishi @ 8/11/2006 6:35:47 PM
RE: performance issue with remote view Posted by Kiran Kumar Singh @ 8/11/2006 7:16:34 PM
RE: performance issue with remote view Posted by Ken Murphy @ 8/12/2006 1:40:04 AM
RE: performance issue with remote view Posted by Nilson Rishi @ 8/12/2006 4:35:12 AM
RE: performance issue with remote view Posted by tushar @ 8/12/2006 1:29:17 PM
RE: performance issue with remote view Posted by Nilson Rishi @ 8/12/2006 5:32:29 PM
RE: performance issue with remote view Posted by Ken Murphy @ 8/12/2006 2:53:31 PM
RE: performance issue with remote view Posted by Nilson Rishi @ 8/12/2006 5:28:46 PM