When I am querying larger tables and want to view the entire output.
Select * from table
I select a cell in the output section and press ctrl+end so all the records will be fetched.
I see the following error.

I am using 4.0.0.13.
My workstation has 16gb ram. I want to allocate as much memory to this as I can so I can query larger tables and see the entire output.