Lists taking a long time to show

My lists are taking over 10 seconds to show unless I have a filter in them.

What could I be doing wrong?

One of the lists shows members sorted by Last Online, 20 per page.
It feels as if the query is getting all of the members rather than the top 20.
When I put in a filter such as `lastvisitDate` >'2014/01/01' it is quite fast.

I have 7,000 members

Joomla 3.2.1
CB 1.9.9

The more members you have the longer it's going to take. You're pulling 7,000 rows all at once then 20 per page is 20 cbUser objects being parsed for fields. Then if you've CB Conditional or CB Privacy they're parsing every single row to remove users and adjust field output as needed. The more you stack on the slower it's going to get. For CB Conditional and CB Privacy you can shut off their usages for userlists for example to reduce their performance hit there. For 20 per page usage be sure you're not loading in dozens upon dozens of fields per user.

Thanks for the reply.

Is there a way to limit lists to a number of results?

I have lists such as 'Latest updated profiles' and LIMIT 200, for example, would be enough.

No, it always pulls as many rows that match the criteria as it can.