When i am running first time sp it will take 30 sec and second time it will execute 1 sec.
My problem is yesterday i am running my report using front end application it will executive success fully(store procedure exe time is 1 sec).but today i am insert some records in the table and running the my report using front end application it will display the time out error and my table have 800000 records.Please check the below my store procedure.How solve the my probelm.
/****** Object: StoredProcedure [dbo].[GetXMLDataCHanges] Script Date: 10-08-2017 19:02:57 ******/
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
ALTER procedure [dbo].[GetXMLDataCHanges]
select Element,convert(varchar(10),[Previous Date],127) as [Previous Date],[Node Name],
[Out],convert(varchar(10),[Current Date],127) as [Current Date],[In]