[wp-trac] [WordPress Trac] #16530: Implement locale based sorting

[WordPress Trac]

#16530: Implement locale based sorting
-------------------------+------------------------------
 Reporter:  cyberskull   |       Owner:
     Type:  enhancement  |      Status:  new
 Priority:  normal       |   Milestone:  Awaiting Review
Component:  I18N         |     Version:  3.1
 Severity:  normal       |  Resolution:
 Keywords:               |
-------------------------+------------------------------

Comment (by dd32):

 Just like to mention here, That sorting is currently mainly done at the
 database level, and then a subselect is done with a LIMIT.

 So at present, using your list, (And a lower limit, lets say 4 per page)
 this is what would be retrieved in chunks:

 - A Book on Software
 - all those things that bug me
 - an apple a day keeps bill gates away
 - books, books and more books!

 - history and stuff
 - lies, damned lies and statistics
 - the history of stuff
 - this tag is totally made up

 - those guys
 - under the bridge
 - zaroo bugs found

 So each of those chunks would be a page, which could then be sorted in
 PHP.

 Loading All items into memory, natural sorting, and then displaying a
 subselection of those is highly innefficient and would likely exceed the
 memory available on many, if not all, web hosts.

 Which basically leaves you either sorting the paged "sorted" options by
 the standard english/language-specific sorting method, Or, Applying the
 ordering at the database level.

 MySQL does not have a Grammatical sorting system that I'm aware of, and
 the Natural sorting methods it offers is mainly for strings containing
 Numbers.

-- 
Ticket URL: <http://core.trac.wordpress.org/ticket/16530#comment:6>
WordPress Trac <http://core.trac.wordpress.org/>
WordPress blogging software