I worked with Join previously and found that It takes around 15-20 min to delete 1 million records from 20 tables.

Then I changed the strategy and first pick and insert...

Does this mean that i need to write my business logic in the sql and return only result set to the web server that need to forward to the client.

All the calculations are made on the server side. I fetch the records from SQL Server Db to RAM and then manipulate the records on server side and at the...

What other ways that i can use to generate the reports for 5-10 million records.

What other ways that i can use to generate the reports for 5-10 million records.

What other ways that i can use to generate the reports for 5-10 million records.

I am calling the SP just one time to get the complete result set.

The used SP return the aggregate data and i am calling the SP 5 million times. One time call return the whole data to code and code do the remaining...

The SP that i am using

CREATE PROCEDURE [dbo].[GetReport]

(

@whereClause varchar(2000),

@orderBy varchar(250) = NULL

)

AS

DECLARE @sqlWhere AS varchar(2000)

SET @sqlWhere = ''

IF @whereClause <> ''

SET @sqlWhere = ' WHERE ' + @whereClause

IF @orderBy IS...

I think about this option but I have following questions in my mind

If I use the temp table then first I need to select the 5 million records from the...