FYI, WooCommerce added the ability to store orders in a separate database table.
Re:WP21
by paulryanrogers on Tuesday May 28, 2024 @09:04AM
(#40500349)
Do you mean table(s)?
Re:WP21
by egman_ekki on Tuesday May 28, 2024 @06:36AM
(#40499281)
> Example : woo commerce.
> Orders ? In the WP_POST db.
No longer true, at least for new installations: https://woocommerce.com/document/high-performance-order-stor...
Ok, sorry for this example. I last worked on one about a year and a half ago.
Re:WP21
by paulryanrogers on Tuesday May 28, 2024 @09:05AM
(#40500355)
Perhaps you mean 'table'?
This was a bit of a reaction to other CMSes that were creating dozens or hundreds of tables, which creates a different set of problems for things like search or overly complex joins.
Re:WP21
by JodieBenitez on Wednesday May 29, 2024 @02:31AM
(#40509113)
Anyone remember the old Spip CMS ? People used to cram every possible content in the _ARTICLES_ loop. Same mistake.
The fact that people use it for something else is what create strong opinions.
Example : woo commerce.
Products ? In the WP_POST db. Orders ? In the WP_POST db.
And in every post about WP it says that using WP_POST for storing your data is good practice.
Well I don't think it is (but it's only my opinion. A strong one).
And the problem is that a LOT of plugins and themes are like that.