Any triggers on this table? These can cause serious speed issues, if not
implemented properly. Any Primary / Foreign keys on this table? You stated you did a data unload. Was this for the entire database or just the one table. If just the one table, I do not believe that helps much. It could be that your indexs are becoming troublesome and you need to do an entire database unload/ reload. (Or try a pack index depending on your version) Network or non-network? Try projecting a temp table .. Project Temp TmpTable from "Your Table" using all This will create a duplicate with no indexes. Try your manual update on this table. If it works fine, then your problem is most likely in your database index file (.xx3) or (more uncommon if you are using a network) a network issue as the temp table most likely resides on your local machine. -Bob ----- Original Message ----- From: "Dan" <[email protected]> To: "RBASE-L Mailing List" <[email protected]> Sent: Thursday, February 11, 2010 7:06:51 AM GMT -06:00 US/Canada Central Subject: [RBASE-L] - Speed issues I am not sure where to turn next. I have a table with about 100,000 rows... updating it seems to take forever. Just yesterday I was manually changing a number in the table, then wanting to go to the next row and change it... (needed to update about 20 rows) Each row took 15 seconds before it would save and update. So, I thought unload the data and reload. That was an hour ago, unload took 2 seconds... reload is still going...If it is going yesterdays speed it will take months. Where am I going wrong?
