NetTalk Central

Author Topic: Slow drop-down box load - best approach?  (Read 4959 times)

rupertvz

  • Sr. Member
  • ****
  • Posts: 326
    • View Profile
    • Email
Slow drop-down box load - best approach?
« on: May 30, 2013, 03:23:32 AM »
Hi Guys,

I have a NetWebForm where the user selects from two drop down boxes.
Unfortunately we have to load the full item master file into these two boxes.
It is taking about 10-20 seconds to complete each load.

Is there some progress indicator that I can put on the NetWebForm to show the user the progress of the load?
Or at least just a "busy" indicator, and prompt to inform the user to wait until the load is complete?



Bruce

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 11250
    • View Profile
Re: Slow drop-down box load - best approach?
« Reply #1 on: May 30, 2013, 05:18:54 AM »
are you doing the load when the form opens, or are you doing it in response to some other selection they make on the form?

cheers
Bruce

rupertvz

  • Sr. Member
  • ****
  • Posts: 326
    • View Profile
    • Email
Re: Slow drop-down box load - best approach?
« Reply #2 on: May 30, 2013, 07:27:06 AM »
Hi Bruce,

I am using the default, both drop-down boxes load when the form opens.
The users are getting impatient and clicking the form away.



Rene Simons

  • Hero Member
  • *****
  • Posts: 650
    • View Profile
Re: Slow drop-down box load - best approach?
« Reply #3 on: May 30, 2013, 09:43:27 AM »
Hi Rupert,

I always take in consideration what the user experience will be when users use my app.
Waiting for a page to load never is good.
When there is a chance that  th droplist will be longer than e.g. 20 items, I use a select function. No waiting time for the user. Happy customer, happy develloper.

Cheers,
Rene
Rene Simons
NT14.14

springguy

  • Full Member
  • ***
  • Posts: 195
    • View Profile
    • Email
Re: Slow drop-down box load - best approach?
« Reply #4 on: May 31, 2013, 03:31:10 AM »
Rene,
Could you fill us in on the technique you are using?
Thanks,
Mike Springer

Bruce

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 11250
    • View Profile
Re: Slow drop-down box load - best approach?
« Reply #5 on: May 31, 2013, 03:52:26 AM »
I think what Rene is saying that a Drop is not an appropriate control when it is either very large (ie lots of options) or populating those options takes a long time.

Change to a String control, click on the "Lookup button" option, and also tick on the "Auto Complete" option. The form loads much faster, and the user still has access to the lookup, and also auto-complete functionality.

cheers
Bruce

springguy

  • Full Member
  • ***
  • Posts: 195
    • View Profile
    • Email
Re: Slow drop-down box load - best approach?
« Reply #6 on: May 31, 2013, 04:34:36 AM »
Thanks Bruce - great info
Mike

Rene Simons

  • Hero Member
  • *****
  • Posts: 650
    • View Profile
Re: Slow drop-down box load - best approach?
« Reply #7 on: June 01, 2013, 12:52:14 AM »
Yeah, autocomplete is even better.
Rene
Rene Simons
NT14.14

Rene Simons

  • Hero Member
  • *****
  • Posts: 650
    • View Profile
Re: Slow drop-down box load - best approach?
« Reply #8 on: June 01, 2013, 03:02:42 AM »
Rupert,
Make sure you have a unique key on the descriprion field of the file that you do the lookup on.
Rene
Rene Simons
NT14.14

rupertvz

  • Sr. Member
  • ****
  • Posts: 326
    • View Profile
    • Email
Re: Slow drop-down box load - best approach?
« Reply #9 on: June 03, 2013, 06:34:27 AM »
Thanks Rene,

Much appreciated :-)