René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Crash by timeout when loading a filtered large table","articleBody":"Precondition:\r\n- There is a PivotTable for 68,000 entries\r\n- This table is used as a drillthrough for another pivot table\r\n- During drillthrough filters are passed to the pivot table input\r\nProblem description:\r\nWhen trying to drill through a cell that contains only 2 values according to filters, the request falls by timeout.\r\nProblem scenario:\r\n- It was found that drillthrough first generates a get query that covers all the pivot table entries and returns html with results that do not match the filters – first 100 row from full table (A similar mdx query via the analyzer returns 2 entries correctly)\r\n- For testing, the number of entries in this pivot table was reduced. The request described above still works incorrectly. But it became clear that the mdxToJSON query is run after it, which returns the correct 2 values.\r\n","author":{"url":"https://github.com/AsyaSokolova","@type":"Person","name":"AsyaSokolova"},"datePublished":"2020-05-05T08:33:39.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":4},"url":"https://github.com/17/LightPivotTable/issues/17"}