Bill, Here is your command removing the table info: EDIT USING Book2 + ARRANGE other BY dealno, + ARRANGE advances BY AdvRdate DESC, + ARRANGE paydeal BY PDpayshare, + ARRANGE rledger BY dealno,RLtrandate DESC, + ARRANGE clroyalties BY dealno, + ARRANGE clsubrights BY dealno,SRRSdesc, + ARRANGE royrec BY dealno,rrtrandate DESC,rrroyalty + + WHERE cno=.vcno AND dealno=.vdealno
Note the following 1. the first arrange is redundant remove it 2. the fourth arrange remove redundant field dealno 3. the fifth arrange is redundant remove it 4. the sixth arrange remove redundant field dealno 5. the seventh arrange redundant filed delno. Also did you intend for rrroyalty to be in DESC order. Each subordinate table to BOOKS will only have records equal to ".vdealno" thus no need to have delno in the arrange statement Jim Bentley American Celiac Society [EMAIL PROTECTED] tel: 1-504-737-3293 --- On Mon, 8/4/08, Alastair Burr <[EMAIL PROTECTED]> wrote: > From: Alastair Burr <[EMAIL PROTECTED]> > Subject: [RBASE-L] - RE: DBGrid Question > To: "RBASE-L Mailing List" <[email protected]> > Date: Monday, August 4, 2008, 5:20 PM > Bill, > > At what point in time are you getting the slow response? > > I have a 6 tab form with a dbgrid on each tab that responds > to the selection > as I click on an item that flips to the next tab > automatically with hardly > any delay. > > Where I may have to wait is on first opening the form as > the data is > obtained and sorted. Clearly, the delay - such as it is - > depends on how > much data has to be processed so my solution is to limit > the data in the > first tab as much as possible. > > Even when I need to use all the data the delay is less than > a minute so I > put a message up to warn. (Believe me, all the data is a > lot of data so some > delay is to be expected - even in R:Base!) Once obtained, > though, selecting > and moving through the tabs, in either direction, is all > but instant - even > with all the data available. > > All I can suggest is that you take another look at all the > columns that link > across the tabs/dbgrids - you might be surprised to find a > rogue one - and > make sure that your keys are helping rather than hindering. > > Good luck, > Regards, > Alastair. > > > > > ----- Original Message ----- > From: "Bill Eyring" > <[EMAIL PROTECTED]> > To: "RBASE-L Mailing List" > <[email protected]> > Sent: Monday, August 04, 2008 10:12 PM > Subject: [RBASE-L] - RE: DBGrid Question > > > > Sami > > > > Thanks for the option. > > > > I had wanted to use a multi-tab form to get away from > individual forms > > which > > I used in 6.5++. I wanted to dazzle using the latest > features of 7.6. > > > > I originally had scrolling regions where the dbgrids > are now and it was > > even > > slower than the dbgrids. > > > > Perhaps scrolling regions or dbgrids are not meant to > be in multi-tab > > forms > > ? > > > > Bill > > > > -----Original Message----- > > From: [email protected] [mailto:[EMAIL PROTECTED] On > Behalf Of Sami Aaron > > Sent: Monday, August 04, 2008 4:21 PM > > To: RBASE-L Mailing List > > Subject: [RBASE-L] - RE: DBGrid Question > > > > Bill - > > > > I switched some forms with multiple tabs/tables to be > MDI forms and found > > that they are really fast. I created a control form > where the user clicks > > a > > button and it opens the appropriate MDI form with the > proper sort order > > and > > no overhead of multiple tables or the > "ARRANGE" clause. > > > > Sami > > > > ____________________________ > > Sami Aaron > > Software Management Specialists > > 913-915-1971 > > [EMAIL PROTECTED] > > > > > > > > -----Original Message----- > > From: [email protected] [mailto:[EMAIL PROTECTED] On > Behalf Of Bill > > Eyring > > Sent: Monday, August 04, 2008 2:41 PM > > To: RBASE-L Mailing List > > Subject: [RBASE-L] - DBGrid Question > > > > I have an 8 tab form used for editing data. On 6 of > these tabs I have a > > dbgrid. > > > > For the tabs with a dbgrid, If I use a dbnavigator > arrow or click on > > succeeding rows the response time is much slower than > if these tabs were > > standalone forms. > > > > The command I use to start this form is; > > > > EDIT USING Book2 + > > TABLE=BOOKS PRIMARY KEY FIELD=DEALNO > > ARRANGE other BY dealno, + > TABLE=OTHER > > FIELD=DEALNO IS A FOREIGN KEY TO BOOKS COLUMN=DEALNO > > ARRANGE advances BY AdvRdate desc, + > TABLE=ADVANCES > > FIELD=DEALNO IS A FOREIGN KEY TO BOOKS COLUMN=DEALNO > > ARRANGE paydeal BY PDpayshare, + > TABLE=PAYDEAL > > FIELD=DEALNO IS A FOREIGN KEY TO BOOKS COLUMN=DEALNO > > ARRANGE rledger BY dealno,RLtrandate desc, + > TABLE=RLEDGER > > FIELD=DEALNO IS A FOREIGN KEY TO BOOKS COLUMN=DEALNO > > ARRANGE clroyalties BY dealno, + > > TABLE=CLROYALTIES FIELD=DEALNO IS A FOREIGN KEY TO > BOOKS COLUMN=DEALNO > > ARRANGE clsubrights BY dealno,SRRSdesc, + > TABLE=CLSUBRIGHTS > > FIELD=DEALNO IS A FOREIGN KEY TO BOOKS COLUMN=DEALNO > > ARRANGE royrec BY dealno,rrtrandate desc,rrroyalty + > TABLE=ROYREC > > FIELD=DEALNO IS A FOREIGN KEY TO BOOKS COLUMN=DEALNO > > whe cno=.vcno and dealno=.vdealno > > > > I confirmed that all of the tables have different > column names except for > > the primary and foreign key. > > > > I am using the latest 7.6 update 7.6.4.30728. > > > > Can anyone point me in a direction where I can speed > things up in these > > dbgrids ? > > > > Thanks in advance. > > > > > > Bill Eyring > > > > > > > > > > No virus found in this incoming message. > > Checked by AVG - http://www.avg.com > > Version: 8.0.138 / Virus Database: 270.5.12/1589 - > Release Date: > > 03/08/2008 13:00 > > > > > >
