Database access · Question 10 of 12

For an overview, only the number of entries on page 12 should be counted. Which implementation is the most efficient?

1 answer is correct. Medium

1. A $qb->select('uid')->from('tx_myext_item')->where(...)->executeQuery()->rowCount()
2. B count($qb->select('*')->from('tx_myext_item')->where(...)->executeQuery()->fetchAllAssociative())
3. C $qb->select('COUNT(*)')->from('tx_myext_item')->where(...)->executeQuery()->fetchAllAssociative()
4. D $qb->count('uid')->from('tx_myext_item')->where($qb->expr()->eq('pid', $qb->createNamedParameter(12, Connection::PARAM_INT)))->executeQuery()->fetchOne()