Wijmo FlexGrid - DataMap - ~18k entries - Slow display

Wijmo FlexGrid - DataMap - ~18k entries - Slow display

Posted by: sricher on 11 June 2018, 3:54 am EST

• 

  sricher

  • Post Options:
  • Link
    Copy

  Posted 11 June 2018, 3:54 am EST

  Hello,

  I have a grid that displays a column using a datamap (Id - Code), the data in there is around 18k rows.

  When I click on the small triangle to open up the drop down, the list takes a good moment to open, quite slow actually.

  When I type, the search as you type is rather fast so that is all good.

  Is there a way I can make that drop down display quicker? The thing is that I might even have more data in there over time.

  Any suggestions?

  Thanks!

• 

  manish.gupta

  

  • Post Options:
  • Link
    Copy

  Posted 11 June 2018, 10:57 pm EST

  Hi,
  
  We were able to replicate the issue at our end and hence it has been forwarded to the concerned team with tracking id 326912.
  
  We will let you know for any updates.

  In the meantime, use ComboBox instead of DataMap for cell levels.

  ~Manish

• 

  sricher

  • Post Options:
  • Link
    Copy

  Posted 13 June 2018, 5:34 am EST

  Hi Manish,

  Thanks for the tip, I’m trying to switch from Datamap to combo box but I’ve not used combobox yet, do you have a link to an example you could share with me?

  For the moment, here is what we are using. The loading time is still a bit noticeable when I double click on a cell to go into edit mode.

  <wj-flex-grid-column [header]=“‘Identifier’” [binding]=“‘underlyingInstrumentId’” [width]=“145” [allowSorting]=“false” cssClass=“cellWithDropDown”>

    <ng-template wjFlexGridCellTemplate [cellType]="'CellEdit'" let-cell="cell">
      <wj-combo-box [itemsSource]="underlyingInstruments" [displayMemberPath]="'tickerAndExchangeCode'" [selectedValuePath]="'underlyingInstrumentId'"
        [(selectedValue)]="cell.value">
      </wj-combo-box>
    </ng-template>
  
  </wj-flex-grid-column>
  

  The problem I have with this is that my column now displays the Id untile I double-click and switch to edit mode for that cell. How would you reccomend I adjust to see the displayMemberPath in my cell while not in edit mode?

  Otherwise, with the datamap, there was a small triangle that was automatically shown that allows in a single click to open up the datamap-drop down menu. With Combo-box, how would you recommend I achieve similar behavior?

  Thanks a lot for the help!

• 

  manish.gupta

  

  • Post Options:
  • Link
    Copy

  Posted 13 June 2018, 7:56 pm EST

  Hi Sricher,
  
  We are sorry, we are able to replicate the delay in showing DropDown for ComboBox too same as DataMap.

  The way you used ComboBox is correct. However, please refer to the following demo sample to get more info about InputControls:
  
  http://demos.wijmo.com/5/angular2/inputintro/inputintro/

  The ComboBox can also be used at Cell level. Please refer to the following code snippet for the same:

  <wj-flex-grid-column [header]="'Identifier'" [binding]="'underlyingInstrumentId'" [width]="145" [allowSorting]="false" cssClass="cellWithDropDown">
  	<ng-template wjFlexGridCellTemplate [cellType]="'[b]Cell[/b]'" let-cell="cell">
  		<wj-combo-box [itemsSource]="underlyingInstruments" 																 
   			[displayMemberPath]="'tickerAndExchangeCode'" 	 			 
  	  		[selectedValuePath]="'underlyingInstrumentId'"
     			[(selectedValue)]="cell.item.underlyingInstrumentId">
  		</wj-combo-box>
  	</ng-template>
  </wj-flex-grid-column>
  

  ~Manish

• 

  sricher

  • Post Options:
  • Link
    Copy

  Posted 15 June 2018, 2:09 am EST

  Thanks for the follow-up Manish, I’ll stick with DataMap for now. Where can I track the issue 326912? Or where can I “register” to receive an update once your team has taken a look?

  Thanks!

• 

  manish.gupta

  

  • Post Options:
  • Link
    Copy

  Posted 18 June 2018, 12:32 am EST

  Hi,
  
  The shared tracking id is internal id. We will update on this as we get an update on this.

  ~Manish

• 

  kyle.m.vassella

  • Post Options:
  • Link
    Copy

  Posted 11 December 2018, 6:40 am EST

  Did this ever get resolved? I’m facing the same issue with a relatively large data source as my data map (~35k records).

• 

  sharad.tomer

  

  • Post Options:
  • Link
    Copy

  Posted 11 December 2018, 6:09 pm EST

  Hi Kyle,

  The issue was addressed by the developer and fix was included in the v2 release 5.20182.500+ which improved the performance significantly as compared to the previous builds.
  
  Here are some of the testing results for the approx time it took to display the drop-down:

  data size	current version(550)	previous version(462)
  5k	~0.4s	~3.8s
  10k	~0.9s	~8s
  35k	~3.2s	~26s
  50k	~4.3s	NA
  100k	~9.5s	NA

  Also, we have asked the dev team if they could improve the performance any further. We will let you know as we get an update on this.

  Regards

• 

  kyle.m.vassella

  • Post Options:
  • Link
    Copy

  Posted 12 December 2018, 5:12 am EST

  Thanks Sharad,

  We’re currently using version 5.20181.462-rc so I’ll update the version in the near future and let you know how it goes.
  
  Also, I found out why sometimes my datamap dropdowns take 1.5 seconds to open and sometimes the same dropdown takes 5 seconds. If I have my browser console window open, this slows the datamap dropdowns significantly, even if I’m not logging anything to the console via console.log. Just a side note for you guys.

• 

  sharad.tomer

  

  • Post Options:
  • Link
    Copy

  Posted 12 December 2018, 7:52 pm EST

  We would recommend you update as soon as possible. Also, please note that rc builds are not tested for production so it is recommended to not use them in the production build.
  
  ““If I have my browser console window open, this slows the datamap dropdowns significantly, even if I’m not logging anything to the console via console.log””
  
  The effect could not be observed with the build 5.20183.550.