search

nicolaskruchten / pivottable

Open-source Javascript Pivot Table (aka Pivot Grid, Pivot Chart, Cross-Tab) implementation with drag'n'drop.
https://pivottable.js.org/
MIT License
4.36k stars 1.08k forks source link

Disable some fields on Drag and Drop box #1006

Open duyhuynhdev opened 6 years ago

duyhuynhdev commented 6 years ago

My data is not big (<30000 records), however, some fields have a number of unique values are over 10.000. That makes the page is very slow and crashed when drag and drop. Therefore, is there any way for disabling those fields which have a number of unique values is over 1000?

thanhtai9606 commented 6 years ago

I think you should set like Pagination in SQL stored or API service first. when move next page it show next record, it easy for you!! Like datatable serverside

duyhuynhdev commented 6 years ago

I think you should set like Pagination in SQL stored or API service first. when move next page it show next record, it easy for you!! Like datatable serverside

The problem is the number of "unique value" of a data field (such as "PRODUCT" has 10000 different values) that makes the number rendered table cell is too big. That leads to a page will be crashed or loaded slowly.

nicolaskruchten commented 6 years ago

It would be fairly easy to accept a list of “draggable” attributes in the API. Not as adaptive as computing this from the cardinality but might meet your needs?

On Mon, Sep 24, 2018 at 21:09 hpduy notifications@github.com wrote:

I think you should set like Pagination in SQL stored or API service first. when move next page it show next record, it easy for you!! Like datatable serverside

The problem is the number of "unique value" of a data field (such as "PRODUCT" has 10000 different values) that makes the number rendered table cell is too big. That leads to a page will be crashed or loaded slowly.

— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub https://github.com/nicolaskruchten/pivottable/issues/1006#issuecomment-424174191, or mute the thread https://github.com/notifications/unsubscribe-auth/AAMbAyE8rFit2q60py-B_bg1CID3Aab5ks5ueYJIgaJpZM4WiuN7 .

duyhuynhdev commented 6 years ago

Currently, I solved the problem by following this way. I just wanna confirm that whether we can solve it in a client-side or not. Because I see a number of unique values is shown on the filter box. So that I think it is possible for using that number for display. But anw, it also be fine to be solved on server side, thank you for your reply.

It would be fairly easy to accept a list of “draggable” attributes in the API. Not as adaptive as computing this from the cardinality but might meet your needs? … On Mon, Sep 24, 2018 at 21:09 hpduy @.***> wrote: I think you should set like Pagination in SQL stored or API service first. when move next page it show next record, it easy for you!! Like datatable serverside The problem is the number of "unique value" of a data field (such as "PRODUCT" has 10000 different values) that makes the number rendered table cell is too big. That leads to a page will be crashed or loaded slowly. — You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub <#1006 (comment)>, or mute the thread https://github.com/notifications/unsubscribe-auth/AAMbAyE8rFit2q60py-B_bg1CID3Aab5ks5ueYJIgaJpZM4WiuN7 .