Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: David Mustakim
  Where is David Mustakim?
 Jakarta
 Indonesia
 David Mustakim
 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: 396170 # Views: 43 # Ratings: 0
Version: Visual FoxPro 9 Category: Databases, Tables and SQL Server
Date: Thursday, January 23, 2014 8:33:54 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


hope TS comes back in soon enough... sometimes this 'unattended fishing method' makes you wonder :-)

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