Skip to main content
Kofax

Database Validation takes long time to connect to the table

1870  ***INTERNAL ONLY***
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:

Softbridge Index Scripts for Kofax Capture / Ascent Capture.

The "ADOLookup" example contains a database lookup.

Applies to:

Product Version
CAPTURE 6.0
  6.1
  7.0
  7.5
  8.0