Database

Lior S wrote:

The main slowing reason that i have encounter is the INSERT and UPDATE command that can be processed for more then 2 minutes

Lior S wrote:

basically the main slowing reason is the UPDATE procedure since it is searching in more then 5 million records to fit to the conditioned row for the update.

Data Source=(local);Initial Catalog=MIDAS;Integrated Security=true;
Data Source=seafire;Initial Catalog=MIDAS;Integrated Security=true;
Data Source=<ipaddress>;Initial Catalog=MIDAS;Integrated Security=true;

oskardiazdeleon wrote:

i.e

datediff(@dateRange, getdate())=0

oskardiazdeleon wrote:

Any Ideas?

CASE @dateRange WHEN 'dd' THEN DATEDIFF(dd, GETDATE(), @someOtherDate) 
                WHEN 'ww' THEN DATEDIFF(ww, GETDATE(), @someOtherDate)
                WHEN 'yy' THEN DATEDIFF(yy, GETDATE(), @someOtherDate)
                ELSE 0 END

CREATE FUNCTION DateDifference(@dateRange CHAR(2), @startDate DATETIME, @endDate DATETIME)
RETURNS INT
AS
BEGIN
RETURN CASE @dateRange WHEN 'dd' THEN DATEDIFF(dd, @startDate, @endDate) 
                       WHEN 'ww' THEN DATEDIFF(ww, @startDate, @endDate)
                       WHEN 'yy' THEN DATEDIFF(yy, @startDate, @endDate)
                       ELSE 0 END
END

SELECT dbo.DateDifference(@dateRange, @someDate, GETDATE())

CREATE PROCEDURE MyFirstProc @cParam varchar(10)
AS
PRINT 'MyFirstProc ' + @cparam
EXEC MySecondProc @cparam
GO

CREATE PROCEDURE MySecondProc @cTest varchar(20)
AS
PRINT 'This is in MySecondProc ' + @cTest
GO

MyFirstProc testing<br />
This is in MySecondProc testing