[rt-devel] 4k ought to be enough for anyone (schema.Oracle
Support in RT)
seph
seph at directionless.org
Tue Mar 18 02:36:24 EST 2003
> Currently all of these columns are of type CLOB. I suggest that moving
> the User table values to VARCHAR(4000) to store 4k of data within them
> *COULD* be a good thing. Can anyone see issues with this?
>
> Users.PGPKey
if this is storing a signed pgp key, 4000 characters seems a little on
the small side.
> This will allow common LIKE queries to work with the Users
>tables. Resulting in less work modifying DBIx::SearchBuilder to
>handle the CLOB data type (this actually won't result is less work -
>but means that some functionality will work without changes to
>SearchBuilder).
why would you ever search on pgp keys?
seph
More information about the Rt-devel
mailing list