Resources
Enik.io - Performance of Views in Drupal 8
Drupal does an entity load on all items in the view, which is a bit too heavy when showing a lot of items without a pager. Here...
Tips
Use a view to customize content author/submitted info
Replace the hardcoded node meta info with a configurable view.
The idea here is to replace the part of the node template where author/date is printed with a view block placed in layout builder.
Use indexed relationship fields in views
Search API can index relationships. To use them, add the relationship and select the field under the Content Relationship category.