Returning >300 rows in MemSQL Studio

Is it possible to return more than 300 rows in the MemSQL Studio query editor?

Also it looks like the “Save CSV” button only saves the 300 rows shown, can it return all results?

Hello @dhenry,

Currently, MemSQL Studio can only return at most 300 rows in the Query Editor for performance reasons.

We have on our roadmap some plans that will allow users to extend this number if they so wish to.

As a temporary solution, you can run:

SET SQL_SELECT_LIMIT = 1234;

in the Query Editor to increase the output limit for that session (this won’t persist as you reopen Studio).

The “Save CSV” takes your last output and downloads it in a CSV file so it is bound by the same constraints as the Query Editor output itself.

1 Like