Author Topic: Copy/Paste taking 4 to 7 seconds in IE8  (Read 5147 times)

Sunny

  • Pro Enterprise
  • Jr. Member
  • *
  • Posts: 59
    • View Profile
Copy/Paste taking 4 to 7 seconds in IE8
« on: April 24, 2015, 11:45:09 pm »
Hi,

I am using the Evaluation version, noticed that copy/paste is taking 4 to 7 seconds while using IE8 browser, not sure if thats because of evaluation version or not. Also noticed same behaviour happening in one of your PRO demos at: Grouping Summary-->ArraySummary/JSONSummary.

Can you please advice why and how to resolve it.

Also, looking for a feature of 'AutoSum' in Excel. If we change value in one grid, the total in other grid should reflect it. Is it possible ?

Thanks.

paramvir

  • Administrator
  • Hero Member
  • *****
  • Posts: 6122
    • View Profile
Re: Copy/Paste taking 4 to 7 seconds in IE8
« Reply #1 on: April 27, 2015, 08:53:40 pm »
1) Please use virtual mode (virtualX: true, virtualY: true ) for faster copy / paste. Both the mentioned demos use non virtual mode.

2) Use cellSave event in first grid to update the value by invoking updateRow on second grid.

Sunny

  • Pro Enterprise
  • Jr. Member
  • *
  • Posts: 59
    • View Profile
Re: Copy/Paste taking 4 to 7 seconds in IE8
« Reply #2 on: April 27, 2015, 09:38:04 pm »
Hi,

Thanks for the reply.

I was already using the virtual mode (virtualX: true, virtualY: true )  property, as my grid contains large data with around 500 rows and 50 columns. Copy/Paste is still slow in IE8, I tried virtual mode in your demo as well which it didn't help either there as well in IE8.

Also here are my properties list on the grid:
var obj = {         
   width: 1300, //width of grid
   height: 450, //height of grid 
   colModel: columns,   
   dataModel: {data: rows},
   sortable: true,
   freezeCols:7,
   collapsible:{on:false,collapsed:false},
   selectionModel: { type: 'cell' },
   editModel: { clicksToEdit: 2 },
                bottomVisible:false,
   filterModel: { header: true, type: 'local' },
   virtualX:true,
   virtualY:true,
   showTitle:false,
   showTop:true,
   showBottom:false,
   roundCorners:true,
                scrollModel:{pace: 'consistent', flexContent:true }
};

Please suggest.

Sunny

  • Pro Enterprise
  • Jr. Member
  • *
  • Posts: 59
    • View Profile
Re: Copy/Paste taking 4 to 7 seconds in IE8
« Reply #3 on: April 28, 2015, 08:36:00 pm »
Hi Admin/Paramquery,

We liked all the features of the Pro version, except the slow performance of Copy/Paste functionality in IE8 which has been as a ShowStopper for us to buy the licensed version.

Can you please provide workaround for this in IE8 ?

Thanks in advance.

paramvir

  • Administrator
  • Hero Member
  • *****
  • Posts: 6122
    • View Profile
Re: Copy/Paste taking 4 to 7 seconds in IE8
« Reply #4 on: April 28, 2015, 09:00:54 pm »
Please do use <!DOCTYPE html> at the top of your web page and double check the virtual mode in demos. Also you haven't mentioned how many cells you tried to copy / paste.

I checked this demo http://paramquery.com/pro/demos/infinite (which is in virtual mode) by copy / paste 10,000 cells (10 rows x 1000 columns).

10,000 cells is good enough benchmark and it didn't take more than a second in IE8 for me.

Please note that copy paste beyond a few thousand cells is bound to be slow as copy/paste functionality in PQ Pro is implemented in pure javascript which has certain clipboard memory constraints.
« Last Edit: April 28, 2015, 09:06:06 pm by paramquery »

Sunny

  • Pro Enterprise
  • Jr. Member
  • *
  • Posts: 59
    • View Profile
Re: Copy/Paste taking 4 to 7 seconds in IE8
« Reply #5 on: May 01, 2015, 11:54:01 pm »
Thank you admin. I tested in my colleagues machine who has Windows 7 with IE8. Its relatively better over there compared to mine, having windows XP with IE8.