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: Borislav Borissov
  Where is Borislav Borissov?
 Sofia
 Bulgaria
 Borislav Borissov
 Tags
Subject: RE: Slow query on network
Thread ID: 373358 Message ID: 373456 # Views: 43 # Ratings: 0
Version: Visual FoxPro 9 SP2 Category: Databases, Tables and SQL Server
Date: Friday, March 22, 2013 8:15:32 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
>
>
> Why you don't have WHERE clause?
> I doubt that you need ALL 200000 records.
> -----------------
> Borislav Borissov
>
> Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
> The only thing normal about database guys is their tables.


thnx
for balance stock
create cursor balance (code c(6), purchase n(10), invoice(10))
select code,sum(quantity) as purchas from purchase group code into cursor pudata
select code,sum(quantity) as invoice from invoice group code into cursor indata
sele balance
append from dbf("pudate')
append from dbf('indate')

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