search

mysticfall / pivot4j

Pivot4J provides a common API for OLAP servers which can be used to build an analytical service frontend with pivot style GUI.
Other
128 stars 101 forks source link

Large embed.xhtml/view.xhtml response body #233

Open lhg-interact opened 6 years ago

lhg-interact commented 6 years ago

We are experiencing slow loadings in our analyzes due to large response body when requesting to embed.xhtml or view.xhtml.

Example of a single cell from grid: <td id="grid-form:col-1576375587" role="gridcell" class="ui-panelgrid-cell row-hdr-cell ui-widget-header" style="padding-left: 40px;"><span id="grid-form:txt-638737670" title="[Data].[2013].[Q1].[Fevereiro].[4]">4</span></td> This is too much data for a single cell, which will show a single character as its content.

Our clients access their analyzes over internet, so large data to be trafficked is a big problem. We have analyzes with sizes over 100MB, which is way too much to be trafficked over internet. Is there a way to make the response body more compact? Or make this table structure to be generated by the client?

ShengtianM commented 6 years ago

You can use “pivotStateManager.getModel().getCellSet()” to get the result data and response the data to the client. Then use client generates the table structure.

lhg-interact commented 6 years ago

This is not the solution i was expecting. I definitly don't want to build my own client from scratch. I was hoping there is a way to reduce the amount of information in the already implemented client from pivot4j-analytics, without breaking anything. Our clients are already used to this layout and its functionalities, so building a new one is very unlikely.

mcastillob commented 6 years ago

I'm corrected this problem long ago. https://github.com/mcastillob/pivot4j/commit/e42967c8461ee477d0dd1ff862eb75bbf30d1a6a.

mcastillob commented 6 years ago

"col-" + column.hashCode(); it can be duplicated when there is a lot of data.

change this for Generators.timeBasedGenerator().generate(); .

fix my versión in https://github.com/mcastillob/pivot4j/releases/download/pivot4j-1.0.1/pivot4j-pentaho-1.0-SNAPSHOT-plugin.zip