How to determine display counts in a table?

Question

Context: I have tabular data in a table that populates dynamically so there could be any number of rows in the table. I do not wish to bombard the user with a long scrolling page so I'd like to set breakpoints in the table and use a display count dropdown so the user can select how many rows show in the table per page.

Here's an example of what I'm talking about:

Question:

How do you determine the breakpoints?

Do you increment by 10,25,50,100,500,1000? or 10,100,1000?

Is there a general rule of thumb or best practice?

Note: Auto-load on scroll will not work in this case as the quantity of data the user sets can be exported under a WYSIWYG model.

Answer 1

Here's a study by the NNGroup that talks about User's Pagination Preference:

Many sites let users choose how many items they’ll see on each page. This is often overkill, as when pop-up menus let users View 10, 20, 30, 40 items per screen.

...

It’s usually better to offer a single default number—such as 10 or 20—and supplement it with View All for people who want more...this design requires only a simple button and is thus much faster to operate.

...

if View All would generate an unwieldy page, give users the choice between two numbers, say 10 and 50, where the second number is substantially bigger than the default.