Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Tore Bleken
  Where is Tore Bleken?
 Stokke
 Norway
 Tore Bleken
 To: Khurram Tahir
  Where is Khurram Tahir?
 Karachi
 Pakistan
 Khurram Tahir
 Tags
Subject: RE: Update command working slow on Lan
Thread ID: 396165 Message ID: 396167 # Views: 63 # Ratings: 1
Version: Visual FoxPro 9 Category: Databases, Tables and SQL Server
Date: Thursday, January 23, 2014 8:11:24 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

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