[Bb-trac] [bbPress] #655: Move slugs to varchar(200)

[bbPress]

#655: Move slugs to varchar(200)
----------------------------+-----------------------------------------------
 Reporter:  mdawaffe        |       Owner:       
     Type:  defect          |      Status:  new  
 Priority:  normal          |   Milestone:  1.0  
Component:  Administration  |     Version:  0.8.1
 Severity:  normal          |    Keywords:       
----------------------------+-----------------------------------------------
 Querying based on slugs as text columns is probably a bad idea for high
 traffic sites with lots of topics.

 I think we should transition all our slugs to varchars.

 This will cut off the ends of some multibyte topic titles/forum names, but
 that shouldn't be too big of a deal (even URLs can only be so long).  It
 will also mean that we'll have to be more careful and less clever about
 how we increment duplicate slugs; we won't be able to just append "-1" to
 things (as that might push it over 200 chars).

 All this while making sure we never cut a string in the middle of a
 multibyte character.

-- 
Ticket URL: <http://trac.bbpress.org/ticket/655>
bbPress <http://bbpress.org/>
Innovative forum development