[wp-hackers] Metadata Mess

[Otto]

On Tue, Dec 22, 2009 at 2:42 PM, Malaiac <malaiac at gmail.com> wrote:
> See, you are focused on portability and one time performance of an
> ALTER table. I'm focused on long term performance of heavily used meta
> tables. No way I'm gonna suffer a VARCHAR search for each and every
> meta. There are sites with more than 20 000 comments on a single page.
> There are sites with more than 30 meta values per post. ...

And those sites are not the norm, and so should be using customized
solutions to solve their specific needs.

If a site has 30 meta values per post and is using them extensively,
then they are doing it wrong. They should be using some form of plugin
with a custom table to handle their needs.

If a site has 20000 comments on a single page, then they are doing it
wrong. They should be using some kind of forum software, or perhaps
"paging" of their comments.

WordPress should not be developing core code to fill the needs of the
tip of the long tail.

-Otto