Hi!

Just put a few temporary useless commands in the BeforeOpenTables event in the data environment. Then use coverage profiles or measuring time between some method calls in the code to investigate which part of the form perform slowly.

>Hi All,
>
>I'm attempting to find bottlenecks in a form that's terminally slow to load.
>
>Here're the things that I know are wrong:
>
>1. Too many controls on the form.
>2. Many tables and views being opened in the DE.
>3. I suspect things like refresh is being called many times.
>
>In the long term, I know the form needs redesigning either with less controls or less tables & views or by instantiating things later.
>
>What I want to do immediately is inspect what's being opened in the DE. Has anyone got any ideas about tactics to investigate what's happening in the DE?
>
>Regards
>
>Paul