ParamQuery grid support forum

General Category => Help for ParamQuery Grid (free version) => Topic started by: mraj on March 22, 2024, 12:22:01 pm

Title: copy paste from excel is slow/not working
Post by: mraj on March 22, 2024, 12:22:01 pm

Hi,
I tried to copy rows from excel . ( Around 15 columns , char, float( decimal 4 digits, int )

For 12000 rows . out of memory exception came.
also in the debugging. getting warnings as


So, i removed all of the column validations.  After that, copied and tried,

For 1000 rows it took 6-7 secs.
For 2000 rows it took around 20secs.
For 4000 rows it took around 1 min.

Getting warnings:
[Violation] 'setTimeout' handler took 6246ms   - pqgrid.min.js
[Violation] Forced reflow while executing JavaScript took 1879ms  pqgrid.min.css:!

[Violation] 'setTimeout' handler took 22034ms
[Violation] Forced reflow while executing JavaScript took 4033ms

Is there any way to avoid /deferred ( DOM painting ) event in the pq grid. Event i commented all the code in cell paste event.


For simple copy paste to notepad. there no issue.


thanks in advance

Title: Re: copy paste from excel is slow/not working
Post by: paramvir on March 22, 2024, 12:53:43 pm

use virtual rendering: virtualX: true, virtualY: true,

Paste of 10,000 rows or 1,00.000 cells takes around 1 second in pqgrid.

Example: https://paramquery.com/demos/copy_paste

Title: Re: copy paste from excel is slow/not working
Post by: mraj on March 22, 2024, 05:51:56 pm

Thanks,

It worked. for paste of 12,000 rows trial. But freeze cols, columns in the grid gets affected/size getting changed. will check further.