Have you read the discussion of ->fetchall_arrayref in DBI? It discusses another way. But if you look at your logic, you will see that your logic returns the complete results at the end of your subroutine. If you want to keep your logic, you will always have to fetch all users.