This topic describes the features of the transactional metadata query.
- Transactional metadata query is supported for both Solr 4 and noindex search subsystems.
- When you enable transactional metadata queries, a query is parsed to check if all of its parts are supported by the database-based query engine. If yes, the database is used automatically.
- Using the database gives transactional consistency as opposed to the eventual consistency provided by Solr 4.
- If you use the transactional metadata query with the noindex subsystem, the search functionality in SkyVault Share won't work as it relies on full text search.
- Normally, a query will be executed against the database, if possible. Database execution of
a query depends on the query itself. It also depends on the application of an optional patch to
the database, which creates the required supporting database indexes. If the supporting indexes
have been created, each index subsystem can be configured to:
- perform transactional execution of queries;
- execute queries transactionally, when possible, and fall back to eventual consistency; or
- always execute eventual consistency.
- The SearchParameters and QueryOptions objects can be used to override this behaviour per query.