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: Anders Altberg
  Where is Anders Altberg?
 Uppsala
 Sweden
 Anders Altberg
 Tags
Subject: RE: Slow query on network
Thread ID: 373358 Message ID: 373454 # Views: 42 # Ratings: 0
Version: Visual FoxPro 9 SP2 Category: Databases, Tables and SQL Server
Date: Friday, March 22, 2013 8:12:18 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
>
>
> In thread Message ID: 373197 there were 400000 rows in Invoice.
> Did you test
> ? DBF('my queryresult alias')
> on the fast query.
>
> How many code groups are there in the second query result?
>
> -Anders

thnx anders
yes i test
first query shows invoice.dbf
and second query shows 95000d.tmp

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