Large data set export may require efficient memory custom php code.
You can review demos/export/custom-export.php and see CSV export code.

Hi,

AS i told you already i am calling web service in the records to get some other info from other app. i can get the data if i didnt call web service for 11K records. if i call any web service for a record then i am getting time out.

THnaks

Reason for timeout is obvious.
An alternate could be to run service and prepare all data n array.

If that's successfully done, you can then pass that data to grid and export.

Hi,

Is it possible to take the grid values in array and create a csv instead calling again query in custom function for export ?

Hi,

Currently it is not doable. We must have another query for export as it is separate call.

Hi,

Please not this as enhancement and work out it. it will be really helpfull for many of the people who will have large number of data's with more number of web service calls. Grid loads as faster but only issues is in export. if you make it like this , then we can export it very quicker.. dont want to depend on memory etc..

One possibility is to use on_data_display event handler.
This is called before data is sent to display as listing.

In that function, you can put the data in $_SESSION variable.
And in export callback code, you can read from that session var and export.

For event help, refer code demos/editing/custom-events.php