We are using JHS 11.1.2.x and JDEV 126.96.36.199.
We have a case where we have over 1200 entries in the JHS_TRANSLATIONS table. The view object is setup to retrieve one row at a time. This can be a bit time consuming on the application side Ideally, we'd want to start increasing the number of rows retrieved. However, the only way I know how to do this would be to create a substitution view to replace the JHS view. Is there a better way of doing this? Right now, this is taking a lot of time to execute and we need to get this time down.