Description of your use case: After a like text search of name, description, process name is implemented, I want to make use of local improvements of a RDBMS to make it faster.
Current Behaviour
LIKE operator of SQL is used (slow).
Wanted Behaviour
Faster implementation accelerated by a RDBMS vendor extension.
Full text search is supported by the following vendors:
Idea: use built-in RDBMS functions, expose them into JPA, and use as part of specification. The function exposure will be vendor specific, the remaining part should be generic.
Scenario
Current Behaviour
LIKE operator of SQL is used (slow).
Wanted Behaviour
Faster implementation accelerated by a RDBMS vendor extension.
Full text search is supported by the following vendors:
Possible Workarounds