Thanks Larry and Mike, I'll look into those possibilities.
Dennis ________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of Lawrence Lustig Sent: Thursday, April 16, 2009 1:35 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: form loading time << 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
