Anonymous wrote on Thu, 28 April 2011 19:06 > Originally posted by: Patrick Schmitz > > To answer the question about DB indexes: some > > indexes are > > automatically setup by Nuxeo, but schema fields are > > not as > > there is currently no way to define what fields > > should be > > indexed. So these custom indexes should be setup "by > > hand" > > in the DB. > > This is unfortunate, as it makes it harder to move > between database > platforms, and seems to increase the risk of upgrading > versions of Nuxeo > (since we must make assumptions about how the VCS uses > the underlying DB). > > It would be much nicer to have an API to control > repository behavior like > this, and like prefetch. Without this kind of support, > making Nuxeo perform > well is a real challenge.
Nevertheless adding SQL-level indexes is usually a task managed by a DBA, and the choice of which indexes to set and how can vary wildly between databases. Having them available in the Nuxeo XML configuration would be a simplification, yes, but nothing fundamental. Also, it's only going to change the performance optimizations of the database, it won't make it work / not work. If a customer is willing to fund addition of XML hints for index setting then we'd be happy to work on it. --- Mailing list: [email protected] Forum: http://forum.nuxeo.org/f/1/
