Dan, For my $0.02, the only safe way to make structure changes is with MULTI OFF.
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 10:57 To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Speed issues Thanks everyone. I will let you know if this fixes it. Right now the table is locked and If I kick all 15 users off again today, they will get ticked. I will come in tonight after hours and turn off the unique setting on the table and make a primary key. Unless someone knows a way to unlock a table that is locked in multi user mode? At 10:38 AM 2/11/2010, you wrote: >If you are sure that the data obeys the rule - and, presumably, you >are - try setting rules off before you do the reload. > >Don't forget to turn them back on when you've finished! > >Regards, >Alastair. > >-------------------------------------------------- >From: "Dan" <[email protected]> >Sent: Thursday, February 11, 2010 2:18 PM >To: "RBASE-L Mailing List" <[email protected]> >Subject: [RBASE-L] - Re: Speed issues > >>sure, >>No Triggers, >> No functions, >> 3 indexes Custno, Invno, IDTrans (all unique numbers) >> 1 rule: Ardetail.INVNO IS NOT NULL AND NOT Ardetail.INVNO IN ( >>SELECT INVNO FROM Ardetail #T1 WHERE #T1.INVNO = Ardetail.INVNO ) >> >> Table: Ardetail No Lock(s) >> >> No. Column Name Attributes >> --- ------------------ >> ------------------------------------------------------ >> 1 CUSTNO Type : TEXT 6 >> Index : SINGLE-COLUMN >> 2 INVNO Type : TEXT 12 >> Index : SINGLE-COLUMN >> 3 SDATE Type : DATE >> 4 IDTRANS Type : TEXT 20 >> Index : SINGLE-COLUMN >> 5 INVAMT Type : CURRENCY >> Default: 0 >> 6 INVCUR Type : CURRENCY >> Default: 0 >> 7 PAYCUR Type : CURRENCY >> Default: 0 >> 8 PAYAMT Type : CURRENCY >> Default: 0 >> 9 CHKNO Type : TEXT 20 >> 10 CHKDATE Type : DATE >> 11 CREDIT Type : CURRENCY >> Default: 0 >> 12 SVCHARGE Type : CURRENCY >> Default: 0 >> 13 CURBAL Type : CURRENCY >> Default: 0 >> 14 AFTER30 Type : CURRENCY >> Default: 0 >> 15 AFTER60 Type : CURRENCY >> Default: 0 >> 16 AFTER90 Type : CURRENCY >> Default: 0 >> 17 OVER120 Type : CURRENCY >> Default: 0 >> 18 SCDROPPED Type : CURRENCY >> Default: 0 >> 19 TOTSVCH Type : CURRENCY >> Default: 0 >> 20 INVBAL Type : CURRENCY >> Default: 0 >> 21 MONTHNO Type : INTEGER >> 22 SC_OK Type : TEXT 1 >> Default: Y >> 23 Posted Type : TEXT 1 >> 24 SYEAR Type : INTEGER >> 25 SPERIOD Type : INTEGER >> 26 batchno Type : INTEGER >> Current number of rows: 100476 >> >> >> >> >>At 09:07 AM 2/11/2010, you wrote: >>>Please post the structure of your table, including a list of >>>indexes, rules, triggers, and constraints that apply. >>>-- >>>Larry >> > > > >> >>No virus found in this incoming message. >>Checked by AVG - www.avg.com >>Version: 9.0.733 / Virus Database: 271.1.1/2681 - Release Date: >>02/11/10 07:35:00 > >
