Do I have to restart my process if changing SQLite table?

[MNelson]

Do I have to restart my processes if I update, or change an SQLite DB that one of the lookups tables is using in my Xlate?

I’ve heard tell that if you are using an SQLite table then you don’t have to restart the process on a change because the select is performed on the table for each lookup, there is no caching.  Is that right, or wrong?

Topic

[John Mercogliano]

Mckay,

  So far from what I’ve seen in 6.1.1 in our test system, cloverleaf does not cache sql data.  Updates in the database table show up the next time a value is looked up. No purging required.

John Mercogliano
Sentara Healthcare
Hampton Roads, VA

[MNelson]

John,

Yay!  And thanks!   😀

McKay

[Author]

Replies