jQuery Grid Plugin - jqGrid

I was creating a grid which has 480 odd columns which includes

"Weekly" i.e. 7 columns,

"Monthty" i.e. 30 columns,

"Quaterly" i.e 60 columns and

"Yealy" i.e. 365 columns

"Additional" 10 columns

Minimum 500 rows, which is 235000 cells that is loaded in DOM.

Scenario 1

So I was thinking to load primary 10 columns which are necessary first and then create a behavior of show hide columns but in this case, I want to load data making a server side call when I click on weekly same way for monthly, quaterly and so on.

Scenario 2

Once I have loaded the data for lets say weekly and I dont to make server call again, once I have the data i want to just show hide columns and not again and again make server calls.

I am looking for this feature.

Has anyone come across this kinda behavior??