<<
We have tried the form compressed and uncompressed, not much difference.
Anyone know any nifty tricks to make the form come up faster?
>>
Are there any lookup control (variable lookup list box, combo box, or listview,
or database lookup list box or combo box) on the form? If so, make sure that
their lookup WHERE clauses are returning a very small number of records or no
records at all (lookup the records later when the user has entered enough
information to limit the returned records). Even if they return a small number
of records, if the records come from a view that must process a large number of
records to get the results, that could slow things down.
Also, check the form's expression list for any inefficient lookups or calls to
stored procedures. The expressions in this list are called more often than you
might imagine.
Finally, look for anything in the BEFORE START and AFTER START EEPs that might
go to disk -- a SELECT or UPDATE command.
You're looking for some data-intensive lookup that will only show itself with
the slower network access speeds.
Try SET ECHO ON and then EDIT USING from the R> prompt. Commands will speed by
as they execute, you may notice that one or two take a noticeable amount of
time.
--
Larry
