Performance Improvement

Question

Hi I am using Mysql 5.1 in my c# application and the performance of an application is very slow so is there any Mysql environment variable to increase the application performance . Is there any way to speed up the performance in a large database Please Help me.

Pedro Barbas · Answer

Hi here is a few considerations to have: Design your data access layer based on how the data is used. Cache data to avoid unnecessary work. Connect by using service accounts. Acquire late release early. Close disposable resources. Reduce round trips. Return only the data you need. Use Windows authentication. Choose the appropriate transaction type. Use stored procedures. Prioritize performance maintainability and productivity when you choose how to pass data across layers. Consider how to handle exceptions. Use appropriate normalization. and some improvements on mysql: http://www.mysqlperformanceblog.com/2006/09/29/what-to-tune-in-mysql-server-after-installation/