The Database Query (DB Query), a processor function, helps the user request data from a database and enrich the data in your stream. The data retrieved from the database can be from multiple tables.
...
Enter a suitable number for Maximum items in cache (0 = no limit). The default value is 100. There is no upper limit to this value.
| Note | ||
|---|---|---|
| ||
A high value can result in an error due to memory outage. If so, the stream fails with the following error message in the log: However, this error is received for memory issues in general and can have other causes than a high value for the maximum number of items in the cache. |
Enter a suitable number of seconds for Items are removed from cache after. The default value is 300. The minimum value is 1 and there is no upper limit to this value.
...