In addition to the other fine suggestions (I like Larry's PK best - and remember, you do not need to separately index any PK or FK columns), you could alternately replace the rule with an INSERT trigger to insure the data integrity, assuming the column cannot be UPDATEd.
Emmitt Dove Manager, Converting Applications Development Evergreen Packaging, Inc. [email protected] (203) 214-5683 m (203) 643-8022 o (203) 643-8086 f [email protected] -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Dan Sent: Thursday, February 11, 2010 09:23 To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Speed issues 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? >
