Is there any way to bypass this limit? I want to download all unlisted topics, and there are a lot of them. A lot more than 10k
For larger queries, you can add pagination to them and get batches that can be merged together ‘off-site’. Something like:
--[params]
-- integer :limit = 10000
-- integer :page = 0
SELECT
id,
title
FROM topics
WHERE visible = false
ORDER BY id
OFFSET :page * :limit
LIMIT :limit
5 Likes
Awesome, thanks
It worked. I just didn’t know how pagination in SQL works
2 Likes
This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.