tmyonline Posted October 12, 2009 Share Posted October 12, 2009 Guys, I have developed many websites over the last three years but have not encountered a website that is as slow as this current one. The only thing I can think of is probably the way I designed my MySQL tables; for one of the tables, I have set a field to "longblob" and another to "mediumblob". I'm wondering if this is the issue because I never used blob in my previous development. Is it better to use longtext for longblob and mediumtext for mediumblob ? Any idea ? Thanks. Quote Link to comment https://forums.phpfreaks.com/topic/177476-my-website-is-extremely-slow-potential-database-problem/ Share on other sites More sharing options...
corbin Posted October 12, 2009 Share Posted October 12, 2009 Well, that depends what you're storing in the columns. What makes you think it's the database? Have you turned the slow query log on? Quote Link to comment https://forums.phpfreaks.com/topic/177476-my-website-is-extremely-slow-potential-database-problem/#findComment-935776 Share on other sites More sharing options...
tmyonline Posted October 12, 2009 Author Share Posted October 12, 2009 Hi corbin, I store just text (article/story/news in Vietnamese) in the database columns. The reason I think it is the database is because, this time, I used longblob and mediumblob, both of which take a lot of space and memory. How do I turn on the slow query log ? If you don't mind, please visit the site: http://coinguon.us to have some idea how slow it is. I never had a site that slow. Thanks so much. Quote Link to comment https://forums.phpfreaks.com/topic/177476-my-website-is-extremely-slow-potential-database-problem/#findComment-935798 Share on other sites More sharing options...
fenway Posted October 17, 2009 Share Posted October 17, 2009 The refman has the appropriate settings. Quote Link to comment https://forums.phpfreaks.com/topic/177476-my-website-is-extremely-slow-potential-database-problem/#findComment-938828 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.