Combo Box cell type is very slow when loading a list with ~1000 elements

Combo Box cell type is very slow when loading a list with ~1000 elements

Posted by: apurushotaman on 29 October 2020, 5:11 am EST

• 

  apurushotaman

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 29 October 2020, 5:11 am EST

  Hello,

  I have a combobox cell type and I am attempting to load the values of the combo-box. It seems to take upwards of 8 seconds to load an array with 1000 elements in the combo-box.

  It seems to call Recalculate Style and Get CSS numerous times during the ‘startEdit’ and ‘showDropDownList’ events. I have attached a sample project and chrome profile dump.

  I would like to know if there is any way we can unbind those events and bind them after the list is loaded.
  
  Also like to know what the best practices are.

• 

  apurushotaman

  • Post Options:
  • Link
    Copy

  Posted 29 October 2020, 5:13 am EST

  I was unable to attach it to the post. I have uploadedArchive.zip

• 

  avinash.pathak

  

  • Post Options:
  • Link
    Copy

  Posted 30 October 2020, 1:08 am EST

  Hi,

  We are able to observe the delay in loading the items hence we have forwarded it to the concerned team for further investigation. We will update once we have any information about the same. The internal ID for this issue will be SJS-6250.

  Further, For best practices you may refer to the following Reference:
  
  https://www.grapecity.com/spreadjs/docs/v13/online/BestPractices.html

  Regards
  
  Avinash

• 

  avinash.pathak

  

  • Post Options:
  • Link
    Copy

  Posted 2 November 2020, 4:13 pm EST

  Hi,

  The dev team is curious about the use case of loading a large number of items in the Combobox. Could you please provide the use case information?

  Regards
  
  Avinash

• 

  apurushotaman

  • Post Options:
  • Link
    Copy

  Posted 25 November 2020, 4:22 am EST

  Hello,

  We have a requirement to load a large number of records (over thousand) in a combo box cell type. The data comes from an ajax call.
  
  Unsure what other information is required at this point. We are currently using a custom cell type using select2 which seems to be faster than the build in combobox cell type but this doesn’t fully serve our purpose and is a lot of work to switch the existing cell types for our current users.

  Unsure how descriptive I can be with the use cases but we have a requirement to populate the combo box with list of employees (which could be over a thousand for some customers), regional information (like cities, states etc… which could span well over 1000 easily sometimes based on the region).

• 

  avinash.pathak

  

  • Post Options:
  • Link
    Copy

  Posted 1 December 2020, 9:21 pm EST

  Hi,

  Thanks for the information. The issue is fixed in our upcoming 14.0.3 build. We will update you here once the build is officially released.

  Regards
  
  Avinash

• 

  avinash.pathak

  

  • Post Options:
  • Link
    Copy

  Posted 6 December 2020, 3:09 pm EST

  Hi,

  The V14.0.3 is released now. Please update to the latest build and let us know if the issue still persists for you. You may also downloade the latest build from here: http://cdn.grapecity.com/spreadjs/14.0.3/Files/SpreadJS.Release.14.0.3.zip

  Further please refer to the following sample that demonstrates the issue fix:

  https://codesandbox.io/s/agitated-paper-rg5q0?file=/src/index.js

  Regards,
  
  Avinash