[#7146] Create MySQL 5 SQL scripts using VARCHAR(MAX)
Summary Create MySQL 5 SQL scripts using VARCHAR(MAX)
Queue Horde Base
Queue Version HEAD
Type Enhancement
State Accepted
Priority 1. Low
Owners
Requester Chuck Hagenbuch <chuck (at) horde (dot) org>
Created 08/02/2008 (121 days ago)
Due
Updated
Assigned
Resolved
Attachments
Milestone
Patch No

History
08/02/2008 Chuck Hagenbuch Comment #1
Patch ⇒
Milestone ⇒
Queue ⇒ Horde Base
Summary ⇒ Create MySQL 5 SQL scripts using VARCHAR(MAX)
Type ⇒ Enhancement
Priority ⇒ 1. Low
State ⇒ Accepted		 Reply to this comment
A number of places where we currently use TEXT fields in database 
tables don't really need BLOB-size data size - horde_perms.perm_data 
for example. With MySQL 5, VARCHARs can be nearly 64k, which is 
plenty, and per http://arjen-lentz.livejournal.com/126316.html, will 
prevent some temp table usage which will speed up permissions queries. 
We should create db-specific fields that make use of that - 
.mysql5.sql for example - for relevant databases.