Add 10 fields and save few articles with them. Create a list with 100 items on frontend and display it.
Single query for all items&fields.
No Code Attached Yet
|Closed_Date||0000-00-00 00:00:00||⇒||2017-03-26 21:59:56|
Reopening. The PR is an improvement but there's still room for better.
I'm not sure if we want to change then tags to work like fields and use the same events there as well as it is the same problem with tags.
If you want to get all fields for articles in one query then IMO you have to use some magic:)
getField() to aggregate all fields and then you have to use magic method
This way, when you start using first value you load all fields.
Off course this is more complicated solution and not always acceptable.