$ds = new MySQLPivotDataSource($db_conn); $ds->select("customerNumber, paymentDate, amount")->from("payments"); //.... $pivot = new KoolPivotTable("pivot"); $pivot->DataSource = $ds; $pivot->AjaxEnabled = true; $pivot->AllowCaching = true;
How can I avoid loading the data from the database over and over? I'd like to load the data only first time if it is not the Ajax callback. Is it possible? For example, the DataGrid has the "ArrayDataSource" data source. I could use it to refresh the grid data from the session variable by Ajax postback. But I did not find similar data source for Pivot. What is the right way to do it?