Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Jim Winter
  Where is Jim Winter?
 Williston
 Vermont - United States
 Jim Winter
 To: Nilson Rishi
  Where is Nilson Rishi?
 Bangkok
 Thailand
 Nilson Rishi
 Tags
Subject: RE: performance issue with remote view
Thread ID: 104117 Message ID: 104129 # Views: 1 # Ratings: 1
Version: Visual FoxPro 9 Category: Databases, Tables and SQL Server
Date: Friday, August 11, 2006 6:22:31 PM         
   


> > The whole idea of client server is NOT to pull down the whole table. Just pull down what you need.
> > Again DON'T pull down whole tables, just the data you need.
>
> But I need to pull down all the data for a table to show on my form, so that users could see all the fields in one glance. They also could use NEXT RECORD/PREVIOUS RECORD/LAST RECORD/TOP RECORD buttons to go through all the rows in the table.
>
> You mean I have to choose between performance and data appearance?
>
> For a CUSTOMER table, if I do not pull down all the fields for all rows, I need to pull down only those key fields such as customer code and name for all rows to have a user select a customer by code or name, and then I need to pull down all the fields for that particular row?
>
> Regards,
> Nilson


That's one way to do it. The other, and I think preferred way, is to let them input identifying data into a parameter, for example, in your customer table it could be the name or some part of it.

Regards,
Jim

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