[RBASE-L] - RE: Slow Scrolling Region

Wed, 20 Jul 2011 12:18:10 -0700

Brad, Dennis
 
DB reloaded, no variables, no lookups, no relational problems - only common column name between the 2 form tables is the idnum. The scrolling region only contains column names. 
 
Bill
 
-------- Original Message --------
Subject: [RBASE-L] - RE: Slow Scrolling Region
From: Dennis McGrath <[email protected]>
Date: Wed, July 20, 2011 10:44 am
To: [email protected] (RBASE-L Mailing List)

Also, when was the last time you reloaded the database?
 
Dennis McGrath
Software Developer
QMI Security Solutions
1661 Glenlake Ave
Itasca IL 60143
630-980-8461
[email protected]
From: [email protected] [mailto:[email protected]] On Behalf Of Dennis McGrath
Sent: Wednesday, July 20, 2011 12:43 PM
To: RBASE-L Mailing List
Subject: [RBASE-L] - RE: Slow Scrolling Region
 
Another thing that could cause that is one or more lookups in the variables for the scrolling region that are not taking advantage of indexes.
 
 
Dennis McGrath
Software Developer
QMI Security Solutions
1661 Glenlake Ave
Itasca IL 60143
630-980-8461
[email protected]
From: [email protected] [mailto:[email protected]] On Behalf Of [email protected]
Sent: Wednesday, July 20, 2011 12:39 PM
To: RBASE-L Mailing List
Subject: [RBASE-L] - RE: Slow Scrolling Region
 
Yes. Makes no difference. 
 
-------- Original Message --------
Subject: [RBASE-L] - RE: Slow Scrolling Region
From: Dennis McGrath <[email protected]>
Date: Wed, July 20, 2011 9:50 am
To: [email protected] (RBASE-L Mailing List)

Does the linking column in the second table have an index?
 
Dennis McGrath
Software Developer
QMI Security Solutions
1661 Glenlake Ave
Itasca IL 60143
630-980-8461
From: [email protected] [mailto:[email protected]] On Behalf Of [email protected]
Sent: Wednesday, July 20, 2011 11:35 AM
To: RBASE-L Mailing List
Subject: [RBASE-L] - Slow Scrolling Region
 
I have several applications uisng the latest version of 9.1-64. In 2 of my applications I have a 2 table form.
The first table contains text data and the 2nd table has a scrolling region containing a linking id, a few text fields and a variable image. The scrolling region is 1 tier high and 5 columns across.
 
When I click on a row in the region, the refresh rate is very slow (from 1 to 3 seconds) before the frame gets focus.
 
Has anyone noticed this ? Does anyone have a suggestion to speed things up. My computers have at least dual core processors and 2 gb RAM.
 
Thanks,
 
Bill Eyring

Reply via email to