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: 373458 # Views: 35 # Ratings: 0
Version: Visual FoxPro 9 SP2 Category: Databases, Tables and SQL Server
Date: Friday, March 22, 2013 8:40:52 AM         
   


> > hello
> > i have 200000 record in table , in server query working fast but on client system query working very very slow
> > * exp
> > select code,sum(quantity) from invoice group by code into cursor indata
> >
> > * index tag
> > index on code
> > index on quantity
> > index on deletted
> >
> >
> > please
>
>
> Make sure that cpdbf() and cpcurrent() shows the same value. If they don't, rushmore doesn't kick in.


?cpdbf = 1252
?current = 1252

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