John,
This probably is not the issue, but at your R> type R>Show QualCols A recent discussion on the list and a test I ran showed that this setting can have a very significant effect on UPDATE commands. The default value is 10 and is what you will probably see. However, if for some reason this value was changed to 2, you would see a significant decrease in speed of the update. Changing the value to 10 would probably solve your issue if this is the case. As I mentioned, the default is 10 so this is probably not the issue, but it is worth checking. -Bob ----- Original Message ----- From: "John Engwer" <[email protected]> To: "RBASE-L Mailing List" <[email protected]> Sent: Monday, November 9, 2009 10:07:53 PM GMT -06:00 US/Canada Central Subject: [RBASE-L] - Update taking a long time I am trying to update a column in temporary table t2008 based on data in temporary table t2007. There are about 4000 – 5000 rows in each table and the column CUST_NO is indexed in both tables. I am trying to figure out why the update takes so long, approximately 3 minutes. That seem like an excessive amount of time with only 4000 rows in the tables. UPDATE t2008 SET Receipt ='Y' FROM t2008 t1,t2007 t2 WHERE t1.CUST_NO = t2.CUST_NO Using V8, 11/02/2009 build John
