10-16-2013 10:15 AM
Is it possible to create an external AFKW set on two or more external tables? If so; could someone point me to some OnBase literature that would help me set this up? Additionally, if this is possible, would the be any drop-off in performance that I could expect as a result of the join?
Thank you!
10-17-2013 10:03 PM
Jim,
Yes it is possible (if they are from the same datasource), though I prefer to use database views instead for simplicity. There is also an Autofill Keyword Sets MRG available. Performance of an AFKW can be dependent on a number of factors including OnBase Client, network speed, ODBC driver, database server performance, table design, query design, indexes etc, etc. Though I have an AFKW that queries a view which has nearly 200m records and returns a match in about 1-2 seconds.
10-18-2013 05:28 AM
Erik:
Thanks for responding. Like you, I prefer having our developers create a view from the LOB (line of business) application, and creating the SQL from it (its so much simpler).
I wasn't aware of the AFKW sets MRG. I'll take a look at it. Thanks for the suggestion!
Find what you came for
We want to make your experience in Hyland Connect as valuable as possible, so we put together some helpful links.