In this example, we will show you how to throttle database updates during peak hours. Designed specifically to control database inserts, the throttleDB module includes code nuances particular to this type of process. We also offer a generic throttling module that you can apply to most other resources (such as web servers).

If you have any questions please contact us at support@interfaceware.com.

How It Works

The process for the throttleDB module is quite simple:

1. It finds the current time.
2. It checks to see if it falls within the specified peak time.
3. If it does, then database access is throttled.

To see the throttleDB module in action:

1. Create a channel with a ‘To Translator’ destination component.
2. Open the ‘To Translator’ script and import this project zip file: Throttled_To_Translator.zip

Here is the cut-and-paste code for main():

local throttled = require 'throttleDB'

function main(Data)
   local T = MapData(Data)
   if T then
      throttled.DoDataMerge(T, db.SQL_SERVER, 'Test', '', '')
   end
end

function MapData(Data)
   local Msg, Name = hl7.parse{vmd='demo.vmd', data=Data}
   local Out = db.tables{vmd='demo.vmd', name=Name}

   -- Map data from Msg to Out here

   return Out
end

Get the latest version of the throttleDB.lua module from our repository.

See Also

• Throttling during peak hours
• throttleDB.lua – module in our repository
• throttle.lua – module in our repository
• Slow/pause code execution – code snippet in our repository