This article has been marked ***INTERNAL ONLY*** as the product version has reached End of Support
Question / Problem:
Why does Database Validation take such a long time to connect to the table?
Answer / Solution:
When Kofax Capture / Ascent Capture connects to a table for Database Validation, it retrieves the entire table contents. So, validating or performing a lookup against a smaller table will be faster than against a larger table.
To avoid the delay caused by this behavior, you may write your own database lookup in a Validation Script.
Sample Validation Scripts are available for download at:
The "ADOLookup" example contains a database lookup.