What are the "no,nos" when using BO Reader?

Hey all, long time listener, first time caller.

We’ve been experiencing a problem in an integration where the BO Reader takes an exceptionally long time to process and our integration times out.

Specifically we are using BOReaderSvc/GetListWithPaging, passing in a where clause of ((CheckBox01=False) AND (CustNum <> 1050))

We need to get all the rows that this applies to, but as I said, it’s timing out.
So my general question is… what’s making this take so long? The query “works” if we set pageSize to 10 but we want all the rows.

What’s the “no, no” that we are doing that’s making the query take so long?

Use a baq BOReader uses get list standard js less than 100 results