Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Bernard Bout
  Where is Bernard Bout?
 Brisbane
 Australia
 Bernard Bout
 To: Nilson Rishi
  Where is Nilson Rishi?
 Bangkok
 Thailand
 Nilson Rishi
 Tags
Subject: RE: performance issue with remote view
Thread ID: 104117 Message ID: 104124 # Views: 2 # Ratings: 1
Version: Visual FoxPro 9 Category: Databases, Tables and SQL Server
Date: Friday, August 11, 2006 5:41:43 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 whole idea of client server is NOT to pull down the whole table. Just pull down what you need. The difference in speed for this is negligible among SPT, Views or Cursor Adapters.

Unless you already have a Framework then you shouls use SPT for ad-hoc queries and either Views or CA's for any data you want to ADD/Delete/Update. These two methods have built in code to build the correct statement for you. With SPT you have to do the work yourself or get a framework.

Again DON'T pull down whole tables, just the data you need.

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