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 > [email protected] > https://mail.kde.org/mailman/listinfo/owncloud _______________________________________________ Owncloud mailing list [email protected] https://mail.kde.org/mailman/listinfo/owncloud
