In Drupal, it is possible to create entity types with multiple options - with or without revisions, fieldable or not and these options have a different performance impact when dealing with functionalities that handle a large number of entities in a single process, so you would want it to be as fast as possible.
Views is a core module that has ability to create simple to complex listings from entities. It is possible to optimize them depending on use cases. Let's cover them.