[wp-trac] [WordPress Trac] #56992: The Loop displays incorrect data for queries started with `fields => 'id=>parent'`.

[WordPress Trac]

#56992: The Loop displays incorrect data for queries started with `fields =>
'id=>parent'`.
-------------------------------------------------+-------------------------
 Reporter:  peterwilsoncc                        |       Owner:
                                                 |  peterwilsoncc
     Type:  defect (bug)                         |      Status:  reopened
 Priority:  normal                               |   Milestone:  6.8
Component:  Query                                |     Version:  3.1
 Severity:  normal                               |  Resolution:
 Keywords:  2nd-opinion has-patch has-unit-      |     Focuses:
  tests dev-feedback                             |  performance
-------------------------------------------------+-------------------------
Changes (by SirLouen):

 * keywords:  2nd-opinion has-patch has-unit-tests => 2nd-opinion has-patch
     has-unit-tests dev-feedback
 * status:  closed => reopened
 * focuses:   => performance
 * resolution:  fixed =>


Comment:

 I left some days ago, because as I said, I was observing several
 performance concerns I want to address here.

 I would like to reopen this ticket because I've observed some issues
 Running last patch: https://github.com/WordPress/wordpress-
 develop/pull/8460

 After running some performance tests, they have shown these results:

 {{{
 Dataset: 1000 posts
 -------------------
   Iterations: 10
     Time: Modified is slower by 16.97%
     Queries: Same number of queries

   Iterations: 100
     Time: Modified is slower by 40.9%
     Queries: Same number of queries

   Iterations: 1000
     Time: Modified is slower by 40.82%
     Queries: Same number of queries
 }}}

 * Modified is the new version

 As I asked some days ago, in my first post, I would like to see a use-case
 where this thing makes sense

 I will upload here the performance testing plugin for further review
 tomorrow.

-- 
Ticket URL: <https://core.trac.wordpress.org/ticket/56992#comment:30>
WordPress Trac <https://core.trac.wordpress.org/>
WordPress publishing platform