How does the same query have different execution times performed in Studio vs. Singlestore Client?
SingleStore Studio, by default, has a SELECT ... LIMIT 300. This may lead to different results compared to the same query without the LIMIT running through the SingleStore client.
Depending on the query options' order, it may result in significantly different query times. To make sure you achieve the same result, specify the same LIMIT on both queries.
SingleStore Studio includes additional functionality to adjust LIMIT to 1,000 or 3,000 rows.
Step 1: In the SQL Editor page, click on the 3 dots and choose Settings
Step 2: Click on the drop-down option for the Limit Results options
To further increase the SQL LIMIT, you can run the following command in the SQL Editor:
SET SQL_SELECT_LIMIT = 5000;
Note: In the SQL Editor, this increase to the output limit is only for the specific session and this will not persist when you reopen Studio.