Mulitple SmartSelects

I have put 5 smartselects on a viewer linked to 5 data objects.
Some of the data objects are parenting other data objects.
All the "open query on start" flags for the SDOs are disable.

  1. CustomerID from SmartSelect Browse from SDO (CUSTOMER1)
  2. CustomerLocationID from SmartSelect Combo (only 1 or 2 per customer) from SDO with CustomerID SDO as parent.
  3. CustomerContactID from SmartSelect Combo (never more than 20 per location) from SDO with CustomerLocationID SDO as parent
  4. DeliveryCustomerID from SmartSelect Browse from SDO (CUSTOMER2)
  5. DeliveryLocationID from SmartSelect Combo (only 1 or 2 per customer) from SDO with DeliveryCustomerID SDO as parent.
The problem:
It takes about 30 seconds (!!!!) to load the screen (yes the programs are compiled). When you run the smartselect browse it comes up straight away. However, I'd rather have a delay at this point rather than one big delay at the beginning.

Should I write my own snap-in for launching a smartdialog to choose my record instead? I'd like to use the tools provided as part of the ADM2 but 30 seconds for a screen with 5 fields on it is a bit excessive.

Any ideas how I can improve load time.


Jon
 
Top