Table view with 1000 + records

  • 1
  • 1
  • Question
  • Updated 1 year ago
  • Answered
I have run across a situation where a table having over 10000 records shows a view (below) where you can list all or do a conditional search. I have a employee that has a table with over 49000 records and his is not doing this. Is this a setting that can be initiated on any table, is it triggered by the number of records and can it be setup to show this view when clicking on any table
Photo of Joey Zint

Joey Zint

  • 1,508 Points 1k badge 2x thumb

Posted 1 year ago

  • 1
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,296 Points 50k badge 2x thumb
If the so called default report is set as the report to use for the Table Home Page report, then QuickBase will detect that there are a too high number of records which will hurt the performance of the app to sort and then start to display, and it will instead put up that search dialogue that you want.

But if you choose, rightly or wrongly, that the Table Home Page report is say the List All report with 49,000 records, then QuickBase assumes that you know what you are doing.

Bottom line - set the Table Home Page Report to be the default report.
Photo of Joey Zint

Joey Zint

  • 1,508 Points 1k badge 2x thumb
So at what point and record count does Quick Base revert to the search option in the view above
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,296 Points 50k badge 2x thumb
I don't recall off hand. My guess is 10,000 records.
Photo of Joey Zint

Joey Zint

  • 1,508 Points 1k badge 2x thumb
I also see that you can set it to Advanced Search Form which will do the same thing
Photo of John Thomas

John Thomas

  • 1,062 Points 1k badge 2x thumb
Table - Customize the page - Under View you can select List all which will show all the records, 

I think what he told is correct , to get a better performance after 10k records they made the Search Filter automatically