[Owncloud] database: enlarge configvalue column | config files

Arthur Schiwon blizzz at owncloud.com
Thu Feb 23 15:21:39 UTC 2012


On Thursday 23 February 2012 14:30:37 Thomas Tanghus wrote:
> On Thursday 23 February 2012 14:06 Arthur Schiwon wrote:
> > Therefore I'd like to enlarge this column to a higher value, e.g. 500. The
> > problem is that MySQL up to version 5.0.2 (incl) only allows VARCHArs with
> > a length up to 255 bytes. 5.0.3 and later allow 65535 bytes.
> 
> +1
> 
> Would it affect performance noticeably it was changed to a TEXT type of
> field? I don't know if they're called the same in SQLite/PostgresSQL.

That is such a small table, I doubt that there are significant changes in 
performance. What might be interesting is to create an key on appid and 
configkey, currently there is none.




More information about the Owncloud mailing list