Mysql 5.0 Server with .NET (ASPX) - mysql database cross size limit - MySQL Database Problems
Discussion by (G)Suraj with 1 Replies.
Last Update: January 26, 2009, 6:47 pm
I have a Mysql 5.0 Server. And same server I host my site coded in .NET (ASPX). My site is goes to the database and pick data from there and display it over internet. Now when my pick time starts at that movment my site is working very slow. Some times it goes time out or page can not be displayed.
I cant understand is this prob. Of mysql or site ?
my database size is approx 4.5 GB.
In advance thanks for help
-question by SurajKeywords:
Though there may be hardware issues I am going to guess that the performance issues are more likely to be a result of poor database and/or query optimization. First take a look at your database design and determine of you have followed the rules of normalization or normal form. Then have someone else take a look at your data model, it never hurts to get a second opinion. Remember you can nad should check up on the health of your database as well.
If you have all your data normalized and modeled well take a look at your queries. With MySQL you can append the the EXPLAIN statement to the front of a SELECT query to see how well it is running. If your SELECT queries are not searching indexes then you will be able to determine where you need indexes based on the information given. Be sure to read the documentation topic about optimization.
|Insert Cd Error - Installing Cs On Vista Cannot Install Adobe Photoshop Cs3 (1)||(0) Need Information about Proxies Help Me To Download Torrent Via Proxy Internet|