Member Avatar for pricolshan

Hi,

I am using Service Oriented Architecture for a payroll application in asp.net vs 2005.

The performance of the application is very slow.
When it goes to the DataAccess Layer from bizprocess it is very slow.

HRMIS.DataAccess.UserDALC objDALC = new HRMIS.DataAccess.UserDALC();

When I declare this object it is very slow to process to the next line.
I am also using Log4net for logger.

Any fine tuning suggestions would be very helpful.

Thanks

  • 2 Contributors
  • 1 Reply
  • 93 Views
  • 2 Days Discussion Span
  • Latest Post Latest Post by Ramesh S
Member Avatar for Ramesh S

What is the functionality of UserDALC() method?

It seems that this method performs some database operation in the back end database which leads to a performance problem.

If so, execute the query or stored procedure and check the time taken to complete the operation. If it takes too long, try to optimize the query and also check if indexes are exists for the fields used in the WHERE clause of the query.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.