Page load issue in .NET web application

Question

I have developed timesheet management system in ASP .NET & MS-SQL for around 500 employees. But having very big issue with speed, few pages and grid-views loads very slow. I have tried everything from update panel to fetching data with all conditions from database itself to reduce page load time. In few pages, there are 2 sub-gridviews. Please help me fix this issue.

Dharmraj Thakur · Answer

Instead of showing data of 4 months provide the option for choosing duration of months. By default it will show last month or current month data, if sometimes you user want to see previous month of data he will filter out. Remember featch only records of dates not all employees attendence data for each row... onclick date popup another form with that particular data of date.

Dharmraj Thakur · Answer

Could you show what data you are getting at a time and what is the query. So we can optimize it.

Shrikesh Kale · Answer

hi, You Can Use to fetch limitade data SELECT * FROM Table_Name ORDER BY Column_List OFFSET Rows_To_Skip ROWS FETCH NEXT Rows_To_Fetch ROWS ONLY

Chaitra V Shetty · Answer

Ok I appreciate your help. Thank you so much

Dharmraj Thakur · Answer

Ya exactly... You have to make common methods with page recordsPerPage and pagenumber parameters and get the data according to command of grid... Its a pagination you need to implement...

Chaitra V Shetty · Answer

Ok thank you so much. I have another question. Is it possible to get only 10 rows at at time from db, & on click of 2nd in pagination, fetch next 10 rows?

Dharmraj Thakur · Answer

Ohkay... Did you implement pagination in your grid?

Chaitra V Shetty · Answer

That can be done only to this page.. There are many other pages with normal gridviews which takes lot of time to load because of number of records in db.. Can you guide me with implementation of lazy loading and data-on-demand?

Chaitra V Shetty · Answer

I have tried the same. But while trying to view "All data", again it takes around 3-4 minutes for records of 4 months. I have heard about lazy loading, but not sure about the implementation with gridview

Dharmraj Thakur · Answer

On form load display only dates and its summry or total info... User will click on Show Detail button of particular date and then specific day's data will be show at a time.

Chaitra V Shetty · Answer

SELECT COUNT(distinct T.ProjectId) as 'TPCount',convert(varchar,convert(date, Date, 103), 106) as 'TDate',T.Date FROM MorningReport T INNER JOIN Admin_Users A ON A.Id=T.UserId INNER JOIN JobTitle J ON J.Id=A.JobTitle INNER JOIN Project P ON P.Id=T.ProjectId INNER JOIN CostCode CC ON CC.ProjectCode=P.Id INNER JOIN Team TM ON TM.CostCodeId=CC.Id WHERE T.Isdeleted=0 AND TM.Isdeleted=0 AND TM.Supervisor=@Id GROUP BY T.Date ORDER BY T.Date DESC SELECT COUNT(distinct T.Id) as 'TJobCount',convert(varchar,convert(date, Date, 103), 106) as 'TDate',T.Date,P.Project_Code,P.Project_Name,P.Id as 'PId',CONVERT(VARCHAR(19),MAX(T.PostedDate)) as 'PostedDate', CASE convert(varchar(5),(DateDiff(s, DATEADD (hh, +8, T.Date),MAX(T.PostedDate))/3600)/24) WHEN 0 THEN convert(varchar(5),DateDiff(s, DATEADD (hh, +8, T.Date),MAX(T.PostedDate))/3600)+'h:'+convert(varchar(5),DateDiff(s, DATEADD (hh, +8, T.Date),MAX(T.PostedDate))%3600/60)+'m' ELSE convert(varchar(5),(DateDiff(s, DATEADD (hh, +8, T.Date),MAX(T.PostedDate))/3600)/24)+'d ('+convert(varchar(5),DateDiff(s, DATEADD (hh, +8, T.Date),MAX(T.PostedDate))/3600)+'h:'+convert(varchar(5),DateDiff(s, DATEADD (hh, +8, T.Date),MAX(T.PostedDate))%3600/60)+'m)' END as 'Delay' FROM MorningReport T INNER JOIN Admin_Users A ON A.Id=T.UserId INNER JOIN JobTitle J ON J.Id=A.JobTitle INNER JOIN Project P ON P.Id=T.ProjectId WHERE T.Isdeleted=0 GROUP BY T.Date,P.Project_Code,P.Project_Name,P.Id ORDER BY T.Date DESC

Page load issue in .NET web application

Answers (11)