Our environment uses lots of text-based lookup files and many, many maps that read them concurrently. We would like to make a design change and instead use a db. The tables are updated every week or two so our thought is to use a local db specific to the Launcher instance. When Launcher starts up it will load the db from the text files, and if the text files are updated a watch event will reload the db.
We have an enterprise Oracle environment but we don't own or manage it, it is not local to Launcher, and it is overkill for these lookup files. I'd like a small, fast, local db, maybe even a memory-only based db that multiple maps in the Launcher engine can access concurrently.
What I'm also really after is a native adapter local db, not a generic ODBC or JDBC.
Is there anything in the 10.1.2 release that is a true local db server? I remember reading something about a Redis server and cache variables that implied the cache variables are maintained in a Redis instance while Launcher is running. If that concept is correct then Redis must be part of the 10.1.2 release.
Given all those ideas and preferences, I'm open to any suggestions on speeding up the use of these lookup text files.
Thanks!
Jim
------------------------------
Jim Davee
------------------------------