[wp-trac] [WordPress Trac] #39691: wpLink autocomplete search improvement

[WordPress Trac]

#39691: wpLink autocomplete search improvement
-------------------------------+------------------------------
 Reporter:  enrico.sorcinelli  |       Owner:  adamsilverstein
     Type:  enhancement        |      Status:  assigned
 Priority:  normal             |   Milestone:  Awaiting Review
Component:  Editor             |     Version:  4.8
 Severity:  normal             |  Resolution:
 Keywords:                     |     Focuses:
-------------------------------+------------------------------

Comment (by pento):

 Thanks for the patch, @enrico.sorcinelli! Checking the collation is a cool
 idea, but I don't think this is the right place for it, for a few reasons.

 There's no real risk to checking the collation, though I don't think that
 there's a benefit.

 Caching strategies should be handled by the caching code - there are many
 places in Core that don't consider the collation's case sensitivity before
 running the query, micro-optimising this one place adds code complexity,
 without addressing the bigger picture.

 For a global query cache, like the one you're describing, that would
 really need to be handled by a specialised caching tool, as it's heavily
 dependent on site behaviour. For example, MySQL is
 [http://mysqlserverteam.com/mysql-8-0-retiring-support-for-the-query-
 cache/ removing it's own Query Cache], because it was never really viable
 as a general caching option.

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