Dan, SET RULES OFF, if at all possible. That RULE is doing an enormous amount of work for every row inserted.
After the load, you can do a single query to find any newly-loaded rows that violate the rule, and deal with them at that point. Bill On Thu, Feb 11, 2010 at 9:23 AM, Dan <[email protected]> wrote: > No triggers, No Primary/Foreign keys, Not a network issue as tables that > are 8 times larger update nearly immediately, and all other indicators are > great speed wise.(gigabit connection to the server) > > Full unload reload of whole database 3 weeks ago for speed issues then as > well. Since this database is in use 24 hours a day I don't know that I can > kick everyone out and re-load the database more often. I know it is a good > habit, however it in the past has never HAD to do it reguarly for speed. I > would do it to keep it under 2 gigs with 7.5 and lesser versions. > > At 08:33 AM 2/11/2010, you wrote: > > 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? >> >> > >
