WordPress.org

Making WordPress.org

Changes between Initial Version and Version 1 of Ticket #174, comment 34


Ignore:
Timestamp:
08/31/2017 12:49:40 PM (23 months ago)
Author:
keesiemeijer
Comment:

Legend:

Unmodified
Added
Removed
Modified
  • Ticket #174, comment 34

    initial v1  
    11I've come to the point were I think this isn't the right way to go about it. Generally the query for related posts is too expensive and the results vary to much.
    22
    3 As an experiment I've tried importing related post ids into post meta after the parser was done. Similarly to how the `Used By` and `Uses` posts are connected after the parser has imported all posts. It took about two seconds to import related posts for every post. This gives you an idea how expensive the query is. It would have taken around 4 hours to import all related posts.
     3As an experiment, to fix the expensive query, I've tried importing related post ids into post meta after the parser was done. Similarly to how the `Used By` and `Uses` posts are connected after the parser has imported all posts. It took about two seconds to import related posts for every post. This gives you an idea how expensive the query is. It would have taken around 4 hours to import all related posts.
    44
    55I think letting users connect related functions as mentioned in [comment:25] would lead to better results with less effort.