• 1. Revise the code to implement the best practices.

    2. Make sure you have appropriate indexes in place and your code in trigger uses it.

    Having these conditions fulfilled you should not have trouble with multiple calls within milliseconds.

    I saw 10 SP calls completed successfully within 0.01 s on a 10 years old server running SQL2000. And those procedures were not ideal ones in terms of optimisation.

    _____________
    Code for TallyGenerator