CloverDM wrote:Yes , this is correct , but think abt the situation every single time the graph inititates the DB look up table has to be loaded ,
Would you think it is a good design ...
The DB lookup table is not loading all the records from the database at the start of the graph. It works more like SQL interpreter and when you want to look up some values in the database, the DB lookup table sends a SQL request and returns the result. Additionally, it can store a defined number of returned results in cache and if you look up values that are already stored in that cache, the DB lookup table reads the values from the cache instead of sending another request. For more information, please refer to our documentation
cpeterson10 wrote:Thanks! Very helpful. It it possible to get a copy go the DB table you used in your example?
I'm sorry, I'm not sure what you mean. If you want to test against the database used in the example, it won't be possible due to the fact it is behind firewall and NAT. If you want to create the table in your database, you can use the following code:
Code: Select all
CREATE TABLE test.dbo.params
key_ nchar( 60),
value nchar( 100)
The above code is for MS-SQL.