When doing an edit on our metavid.org site the following query takes up 
to 70 seconds:
INSERT /* SMW::makeSMWPageID */ INTO `smw_ids` ( smw_id, smw_title, 
smw_namespace,
after it runs it only takes a fraction of a second to insert the next 
edit you do.

Has anyone else run into this issue and have any mysql configuration 
suggestion for keeping the large indexes in memory so that inserts don't 
take so long?

--michael

------------------------------------------------------------------------------
This SF.net email is sponsored by:
High Quality Requirements in a Collaborative Environment.
Download a free trial of Rational Requirements Composer Now!
http://p.sf.net/sfu/www-ibm-com
_______________________________________________
Semediawiki-devel mailing list
Semediawiki-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/semediawiki-devel

Reply via email to