>>>>>a 1/2 sec. Screen refresh?
>...
>>>No Filters - Other Apps showed Unacceptable Performance
>>>No Page Framing.
>>>No Grids Yet - Later will implement Optimized Grids described by FoxAdvisor.
>>>Record Buffering is @ 3.
>>>No Screen Code - Toolbar uses _screen.activeform.refresh
>>>App Contains Four Formsets each use the same Toolbar.
>>>Controls = 126 but only 51 sEEn at one time - I HAVE
>>>made a simular form with only 50 controls - No Performance Increase!
>>>Controls are 56 DataFields and the rest are Shapes or Labels.
>>>Child Table has TWO memos out of 57 fields.
>>>Parent consist of 18 Fields.
>>
>>Edgar (Ed?)
>>
>>Try adding a 'thisform refresh' to each form and see if this speeds things up. I don't use Formsets because I found they were substantially slower than separate forms.
>>
>>HTH
>>Barbara
>
>Barbara - I'll answer to: (Ed)gar, or HEY You
>The Toolbar is identical to another App (having no Filter).
>Toolbar required - user specification!
>The Users TRACK 3 Contengencies, thats why the filtering...
>What is the best way to Filter Data? I see that in the DBC
> Parent Child Filtered
>candidate tagkeymd <->> tagkeymd regular tagkey= "MD"
>candidate tagkeytd <->> tagkeytd regular tagkey= "TD"
>candidate tagkeyst <->> tagkeyst regular tagkey= "ST"
>primary tagkeyall<->> tagkeyall regular
>Maybe I should Filter a different way???
>RI= Cascade Update; Cascade Delete; Restrict Insert
>This is a large tracking system for `100 (ISO9000 reg) users!
>The Four Formsets are really the same - the user sees diff Labels.
>Should I use only one Formset?(even though I use only 1 at a time)
> Thanx Ed B


Hey, YOU, Ed - EDGAR!! (got everyone I think)

I'm confused. Do you have a filter here? If so, that's almost certainly your culprit. Use a parameterized view instead, where the parameter is on an indexed field. Very fast.

Barbara