There is a limit clause to SQL queries that you can use if you're worried about efficiency. Obviously, you can use a count query to get the total number without the overhead of actually retreiving all of them.