ParamQuery grid support forum

General Category => Help for ParamQuery Pro => Topic started by: youngvan on March 03, 2015, 09:16:48 pm

Title: virtualXHeaderType and slow sorting
Post by: youngvan on March 03, 2015, 09:16:48 pm

Cheers!

Here is my problem:
I have lot number of columns and few-level header in my table, so I need to set virtualX: true and virtualXHeaderType: false (to display rowspan and colspan correctly). Grid works fine but there's one problem with sorting- it works slow -up to 5 sec. If I set option virtualXHeaderType: true -it work very fast though header displays not properly  :(.
Is it possible to speed up sorting in grid with disabled virtualXHeaderType?

Thanks in advance!

Title: Re: virtualXHeaderType and slow sorting
Post by: paramvir on March 04, 2015, 12:04:45 am

How much is the initial binding and refresh time.

Could you please share a jsfiddle.

http://jsfiddle.net/b6b710mz/9/

Title: Re: virtualXHeaderType and slow sorting
Post by: youngvan on March 04, 2015, 04:40:22 pm

Here's my jsFiddle:
http://jsfiddle.net/b6b710mz/60/

Try to test sorting with virtualXHeader true and false.

Thanks!

Title: Re: virtualXHeaderType and slow sorting
Post by: paramvir on March 04, 2015, 06:14:56 pm

I found the script for resizable columns is slowing it down, it would be optimized in next version.

Meanwhile you can use resizable: false to make the sorting and refresh time faster.

Code: [Select]

columnTemplate: {resizable: false},

http://jsfiddle.net/4Ldz3anx/

Title: Re: virtualXHeaderType and slow sorting
Post by: youngvan on March 04, 2015, 06:35:51 pm

Thank you very much!
I look forward for new version.

Title: Re: virtualXHeaderType and slow sorting
Post by: paramvir on March 24, 2015, 11:59:06 pm

Performance related to this issue has been optimized in v2.4.1