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
 Tags
Subject: Slow query on network
Thread ID: 373358 Message ID: 373358 # Views: 57 # Ratings: 0
Version: Visual FoxPro 9 SP2 Category: Databases, Tables and SQL Server
Date: Thursday, March 21, 2013 3:06:24 PM         
   


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

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