We have a requirement to display actions from an external source. Essentially a group of action get updated on a semi regular basis that we pull from an external DB to populate. These need to be updated on a daily basis and can number in the tens of thousands. What would be the best way to implement such a requirement. Each user will only likely qualify for 3 or 4 of these actions but they are extremely high in importance. They can be broken down into 4 categories but it is possible that all the action come from the same categories.

My first thought was to import the action in a nightly scheduler, but that may be over taxing to the system as the import process takes awhile to run.

Any suggestions on approach would be greatly appreciated.

Thanks,

Brian