Dan,
Indexes are only meant to increase the speed of identifying rows, not the actual update. So you definitely do not want to add indexes to the columns you are updating. That would actually slow down the process as you would now be updating the indexes as well as the data. Updating 100,000 rows should not take too long, so something is certainly askew. So some things to check... Look at your setting for QualCols R:>sho qualcols QUALCOLS is set to 10 If it is not set to 10, then set it. This can make a significant difference. Unload and Reload the database if you have not already done so. If there have been much row deleting etc. sometimes the database files need packed. Although I am hard pressed to think this would cause an hours long update. Try updating just one column at a time and see if the time is different and report back. Make sure you are running the latest version. There were changes made that directly effected speed in certain cases. -Bob ----- Original Message ----- From: "Dan" <[email protected]> To: "RBASE-L Mailing List" <[email protected]> Sent: Wednesday, January 6, 2010 6:25:51 AM GMT -06:00 US/Canada Central Subject: [RBASE-L] - Update command taking forever Hi, We have finally made the conversion to Turbo 8, and am having troubles with my month end financial processes. I assumed it was index problems and made sure there are indexes. Update ardetail set invcur = 0, paycur = 0 used to take seconds in 7.5 26 hours and counting in turbo in 7.5 neither invcur nor paycur had indexes. I added them now, and still no increase in speed. So then I thought, ok with the new indexes, lets key just off those.. Update ardetail set invcur = 0 where invcur <> 0 (excluding 95000 rows) only 1300 should now be looked at, and this still takes forever. Where should I look next?
