[wp-trac] [WordPress Trac] #55004: WP_Query IN operator has limits

[WordPress Trac]

#55004: WP_Query IN operator has limits
---------------------------+------------------------------
 Reporter:  hajakutbudeen  |       Owner:  (none)
     Type:  defect (bug)   |      Status:  assigned
 Priority:  normal         |   Milestone:  Awaiting Review
Component:  Query          |     Version:
 Severity:  normal         |  Resolution:
 Keywords:  close          |     Focuses:
---------------------------+------------------------------
Changes (by peterwilsoncc):

 * keywords:  dev-feedback => close
 * version:  5.9 =>
 * component:  Database => Query
 * severity:  major => normal


Comment:

 Hi @hajakutbudeen and welcome to trac.

 I'm not sure how many posts are in the 19,000 character string but even
 presuming six character post IDs (7 characters with a comma), it would be
 approximately 2,700.

 WordPress is not designed to query that number of posts a single request
 (no CMS is), nor is using post IDs the recommend approach to return all
 posts from a particular `post_type`.

 For assistance using the shortcode, I recommend you ask in the
 [https://wordpress.org/support/plugin/woocommerce/ Woocommerce support
 forum].

 I suspect the number of posts queried is causing WordPress to run out of
 memory somewhere so I am going to recommend this ticket be closed but will
 ask another person to review it before doing so.

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