select * from table limit 100 is faster

• Using 'select * from table' retrieves all rows from the table, which can be slower if the table is large

• Using 'select * from table limit 100' limits the number o...read more