On Mittwoch, 26. September 2007, Yaron Koren wrote: > On discoursedb.org, we changed the "value_xsd" field to be of type "text", > and haven't had any performance issues as a result.
Interesting. Yet I read that MySQL indices will get slower when indexing larger data items. Can anyone comment on whether or not DB performance would be impacted by this (also w.r.t. to using the table for other joins that are not related to the TEXT field -- if the table and index requires more memory, this might affect some operations). -- Markus > > -Yaron > > On 9/25/07, S Page <[EMAIL PROTECTED]> wrote: > > Folger, Deborah H wrote: > > > Currently our attributes of type string are limited to 255 characters. > > > We need to increase the size of type string to about 8K. > > > Has anyone experienced issues with having an attribute string size of > > > 8K? > > > Effect query execution time, performance, etc. > > > > No, I haven't tried. I would search for 255 and 256 in the code (it > > should be a constant...). SMW_DV_String.php has a check for length and > > SMW_SQLStore.php creates > > 'value_xsd' => 'VARCHAR(255) NOT NULL', > > > > That column is used for nearly every attribute (every property that's > > not a Wiki page in 1.0), so obviously there's a hit in database size. > > > > > > Note that SMW 1.0 will (probably) have a Type:Text that does not have a > > length limitation; the tradeoff as I understand it that you can't query > > for particular values of it. Try it out, > > http://ontoworld.org/wiki/Property:Text_test > > > > -- > > =S Page > > > > ------------------------------------------------------------------------- > > This SF.net email is sponsored by: Microsoft > > Defy all challenges. Microsoft(R) Visual Studio 2005. > > http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/ > > _______________________________________________ > > Semediawiki-user mailing list > > [EMAIL PROTECTED] > > https://lists.sourceforge.net/lists/listinfo/semediawiki-user -- Markus Krötzsch Institut AIFB, Universät Karlsruhe (TH), 76128 Karlsruhe phone +49 (0)721 608 7362 fax +49 (0)721 608 5998 [EMAIL PROTECTED] www http://korrekt.org
pgp7HRnw0hbQ4.pgp
Description: PGP signature
------------------------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/
_______________________________________________ Semediawiki-devel mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/semediawiki-devel
