Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Increase limit on datastore_search_sql results #32

Open
drw opened this issue May 25, 2023 · 1 comment
Open

Increase limit on datastore_search_sql results #32

drw opened this issue May 25, 2023 · 1 comment

Comments

@drw
Copy link

drw commented May 25, 2023

On the new CKAN instance, this is like 32,000. On the old, one we had it set to 500,000 (if I recall correctly). The variable to set in the site's configuration file is ckan.datastore.search.rows_max.

@drw
Copy link
Author

drw commented Jun 3, 2023

I'm having second thoughts about this. The reason we did this in the first place was because the low cut-off caused users to get 32,000 records and think they had everything. But I'm wondering if large API calls might have led to the overloaded database problems we've experienced. Maybe we should think instead about teaching users about navigating paginated results. We could do a better job of documenting how to look for pagination-limited search results.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant