Application is very Slow

Dear All,

Finally I completed my project. Thanks all you helped me to do it.

Now I have the biggest problem.

In my application the Data grid is filled with Data from SQL server table which has large number of records. When I run my queries in SS Management Studio it runs very fast. To fill data to datagrid it takes lots of time. How can I reduce this time. How can I increase the performance of my Application.

Thanks,

Janaka

Try to disable debugging and trace in your web.config after deployment.

Also for large amount of data you can use a custom paging solution to paging through data to prevent getting all the data which for sure affect the performance.

|||

Thanks I did custom paging its amazing. Now ok.

Again another problem.

Users edit some records in Gridview and click update button. Data will be updated in SQL table. But I want to track what are the records actually edited.

Do you have any idea?

thanks,

Janaka

|||

You may do this in many ways:

- You can handle the GridView RowUpdated event and log the information to say Database table ( Data may be : current login user id , Update time stamp,record id)

|||

Hi,

You understood what I have to do clearly. But in multi editing grid view, row updating event is not firing. Because when page loading the grid is in editable mood and there is no edit button or update button inside the grid for each and every row.

Thanks,

Janaka