Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Khurram Tahir
  Where is Khurram Tahir?
 Karachi
 Pakistan
 Khurram Tahir
 To: Tore Bleken
  Where is Tore Bleken?
 Stokke
 Norway
 Tore Bleken
 Tags
Subject: RE: Update command working slow on Lan
Thread ID: 396165 Message ID: 396173 # Views: 42 # Ratings: 0
Version: Visual FoxPro 9 Category: Databases, Tables and SQL Server
Date: Thursday, January 23, 2014 9:10:51 AM         
   


> >
lnInvNo = 450

> >
> >
UPDATE Stk_Tbl FROM Sale_Tbl SET Chckd = .T. ;
> > 	WHERE Sale_Tbl.ItemNo = Stk_Tbl.ItemNo AND Sale_Tbl.Invoice_No = lnInvNo
> > 

> >
> > Sometime work fast and sometime very very slow especially on Network Pcs
> >
> > Above command marked items of Specific Sale Invoice Items in Stock table
>
> Do you have index tags on ItemNo in both tables, and on Invoice_no in Sale_tbl?
>
> There's a fine line between helping and adding to the confusion.
>
> How to create sample data



Yes both tables has required tags (already created)

ENTIRE THREAD

Update command working slow on Lan Posted by Khurram Tahir @ 1/23/2014 8:02:21 AM
RE: Update command working slow on Lan Posted by Tore Bleken @ 1/23/2014 8:11:24 AM
RE: Update command working slow on Lan Posted by David Mustakim @ 1/23/2014 8:33:54 AM
RE: Update command working slow on Lan Posted by Khurram Tahir @ 1/23/2014 9:10:51 AM
RE: Update command working slow on Lan Posted by Tore Bleken @ 1/23/2014 9:30:45 AM
RE: Update command working slow on Lan Posted by Khurram Tahir @ 1/24/2014 7:44:25 AM