Author Topic: Do pivot with bigdata?  (Read 1618 times)

resolvecomputing

  • Pro Ultimate
  • Newbie
  • *
  • Posts: 40
    • View Profile
Do pivot with bigdata?
« on: May 09, 2018, 04:58:40 pm »
If I do pivot with more than 3 million record, the paramquery posible do that?

paramvir

  • Administrator
  • Hero Member
  • *****
  • Posts: 6310
    • View Profile
Re: Do pivot with bigdata?
« Reply #1 on: May 09, 2018, 10:10:24 pm »
There is no set limit on number of records in pqgrid, however there are constraints like CPU speed, RAM size, browser.

Practical way is to start with a moderate number of records and gradually increase it till pivot time is acceptable.