On Nov 5, 2011, at 10:46, Brandon Phelps <bphelps@gls.com> wrote:
> On 11/5/2011 10:35 AM, Raymond O'Donnell wrote:
>> On 05/11/2011 04:34, Brandon Phelps wrote
>
> With the method you outlined will I notice any huge performance impacts? The application would be parsing incoming
datafrom another 3rd party application and could, at times, be executing the function in very fast succession, although
nevertwice at the exact same moment (single threaded application, pending events will just block until they're up).
>
> Thanks again!
>
You would probably be much better off importing the third-party data into a staging table, performing all of your "key"
creation,and then inserting the data into your final tables.
While triggers would work you end up with a lot of pointless effort when in most cases keys are likely to exist.
David J.