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.
Loading
Pedro BarbasPosted Aug 19, 2009, 8:39 AM
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/