Performance improvement for My C# application

Question

Hello All I am working on ERP project in C# Desktop Application. I have been facing performance issues while saving..updating or deleting data. It takes a lot of time for execution. I want to improve performance of project. Please suggest what changes should I do in code level and sql server level. I am currently using SQL server 2014 and visual studio 2012. Thanks & Regards Suraj.

Ramesh Palanivel · Answer

Hi Suraj Which mean the problem is not from your code your sql server may slow... write the insert query directly in sql server and test it whether it executes immediately or not..Check your code with break point whether it has any looping ? if you have any looping in insert query plz avoid it.

Suraj Kumbhar · Answer

Hi Ramesh Yes We have deployed it on client machine and facing performance issues at their machine as well. It takes more than 60 seconds to save.

Ramesh Palanivel · Answer

Hi suraj Sometimes your application may getting slow because of running from visual studio.. Deploy and run it in client machine.. It should be fast... Try and let me know!.

Suraj Kumbhar · Answer

Hello Ramesh Thanks for your suggestion. But We have used stored prcedures at DB level.

Ramesh Palanivel · Answer

Hi Suraj Avoid writing insert update and delete in c# code write those codes in sql stored procedure.it will be much faster than c# code. Try to use triggersviews and functions to avoid repeated codes... It will help you!..