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
