SQL query only returns 100 rows

User Talk Base design
1

Why is my SQL query, using the REST API, only returning 100 rows? The table I am querying currently has over 5000 rows. This is the query I am running:

“{”“sql”“:”“select * from MyTableName”“,”“convert_keys”“:true}”

I am only getting 100 rows back.

2

You need to explicitly add limit 5000 to get 5000 rows.

The design is to prevent overload for SeaTable server. Unlike traditional database like MySQL, SeaTable server is intended to be used directly by thousands of end users.

3

Thank you. That worked. Is that stated anywhere in the documentation?

4

Thanks for asking: I added this default value to Query SeaTable with SQL.

5

This topic was automatically closed 2 days after the last reply. New replies are no longer allowed.