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]<mailto:[email protected]>> Date: Wed, July 20, 2011 9:50 am To: [email protected]<mailto:[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 [email protected]<mailto:[email protected]> ________________________________ From: [email protected]<mailto:[email protected]> [mailto:[email protected]<mailto:[email protected]>] On Behalf Of [email protected]<mailto:[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
