Hi,

I have one main table and doing different calculation and populating around 10 tables. For this I've created 10 stored procedures and executing it. All these stored procedures are either bulk insert or bulk update based on some criteria. To execute this entire set of insert/update SPs it currently takes around 2hrs.

Right now we are dealing with 1 million records in each table.

Please tell me, If I use LLBLGEN and convert my stored procedures to .Net will it decrease my execution time?

Of course it depends on what you're doing exactly but executing ten update statements in a single stored procedure will be faster than sending 10 requests from an external .Net application. No matter if the job is done with llblgen pro or not.

I agree with stefcl.