Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Ayaz Ahmad
  Where is Ayaz Ahmad?
 Peshawar
 Pakistan
 Ayaz Ahmad
 To: Tore Bleken
  Where is Tore Bleken?
 Stokke
 Norway
 Tore Bleken
 Tags
Subject: RE: Slow query on network
Thread ID: 373358 Message ID: 373460 # Views: 37 # Ratings: 0
Version: Visual FoxPro 9 SP2 Category: Databases, Tables and SQL Server
Date: Friday, March 22, 2013 8:47:44 AM         
   


> >
> >
> > ?cpdbf = 1252
> > ?current = 1252
>
> I would try to select all the records but only the necessary fields from the server into a cursor, and then run the same query against the cursor. And if possible, limit the number of records, do you really need to process 200000 records?



yes for balance quantity

ENTIRE THREAD

Slow query on network Posted by ayaz ahmad @ 3/21/2013 3:06:24 PM
RE: Slow query on network Posted by Borislav Borissov @ 3/21/2013 3:54:21 PM
RE: Slow query on network Posted by ayaz ahmad @ 3/22/2013 8:15:32 AM
RE: Slow query on network Posted by Anders Altberg @ 3/21/2013 6:29:44 PM
RE: Slow query on network Posted by ayaz ahmad @ 3/22/2013 8:12:18 AM
RE: Slow query on network Posted by Tore Bleken @ 3/22/2013 8:39:42 AM
RE: Slow query on network Posted by ayaz ahmad @ 3/22/2013 8:40:52 AM
RE: Slow query on network Posted by Tore Bleken @ 3/22/2013 8:45:19 AM
RE: Slow query on network Posted by ayaz ahmad @ 3/22/2013 8:47:44 AM