Performance improvement for My C# application

Suraj Kumbhar

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.

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Ramesh Palanivel9y ago
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 Kumbhar9y ago
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 Palanivel9y ago
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 Kumbhar9y ago
Hello Ramesh,
Thanks for your suggestion. But We have used stored prcedures at DB level.
Ramesh Palanivel9y ago
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 triggers,views and functions to avoid repeated codes... It will help you!..