[Owncloud] database: enlarge configvalue column | config files

Arthur Schiwon blizzz at arthur-schiwon.de
Fri Feb 24 13:18:48 UTC 2012


On Thursday 23 February 2012 16:21:39 Arthur Schiwon wrote:
> 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.
Oversaw this one. MDB2 should take care of it.

MDB2 also make use of LONGTEXT instead of TEXT, at leat in MysQL and SQLite.

> 
> 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.

I played a bit with it, simply changing this col to LONGTEXT is fine us.

Cheers
Arthur

> 
> _______________________________________________
> Owncloud mailing list
> Owncloud at kde.org
> https://mail.kde.org/mailman/listinfo/owncloud



More information about the Owncloud mailing list