Leave a comment at the end of this page or email contact@krishagni.com
Why DB Console limits 100 rows?
The OpenSpecimen DB Console is designed for quick data verification and checking specific records. To maintain good performance and stability for all users, the DB Console displays a maximum of 100 rows per query.
The 100-row limit cannot be changed.
Use the DB Console for:
Checking a small set of records
Verifying specific data
Investigating data issues
Performing quick sanity checks
Do not use the DB Console for:
Viewing complete database tables
Extracting large datasets
Retrieving thousands of records through the web interface
Why is the Limit 100 Rows?
Displaying a large number of records can affect both the application and database performance:
Browser Memory: Large result sets use more computer memory because the browser needs to load and display every row.
UI Performance: Large result sets can make the page slow, cause scrolling/input delays, or even make the browser unresponsive.
Database Performance: Large or long-running queries consume database resources and connections, which can slow down OpenSpecimen for other users and background jobs.
Need All Records?
If you need to retrieve all records from a database table, connect directly to the database VM and run the query there instead of using the DB Console.