bgetting Posted February 12, 2007 Share Posted February 12, 2007 We have a website that has a lot of PHP code in it, and a lot of calls to MySQL, and we are experiencing performance issues as our traffic increases. Of course, I take the blame since I am a designer that learned PHP, and I believe the real programmers call what I have done "spaghetti code", or a lot of basic PHP sprinkled throughout templates. I imagine that this could be the cause of the problem, and that I need to look at creating a better application model using classes and such. Adjusting the MySQL cache size, removing persistent connections, and such have not been working. Here is my question. How do I go about pinpointing exactly what is causing our performance issues? From there, how do I go about getting in touch with someone that could help with those issues? If anyone is interested in taking a crack at this, I would be happy to speak with them. Please IM me if there is any interest in doing some freelance work, and if you need any more information please let me know. I'd be happy to post it here. Thanks for any help that someone can give. BTW, by performance issues I mean that it is taking a long time to load the pages, which just started recently. The only change has been the amount of traffic that we are getting. Link to comment https://forums.phpfreaks.com/topic/38240-performance-issues/ Share on other sites More sharing options...
redarrow Posted February 12, 2007 Share Posted February 12, 2007 Increase the bandwidth sounds like you have come to your bandwidth limit, contact the hosting company there tell ya. Link to comment https://forums.phpfreaks.com/topic/38240-performance-issues/#findComment-183169 Share on other sites More sharing options...
bgetting Posted February 12, 2007 Author Share Posted February 12, 2007 Our bandwidth reports are not showing that. The hosting company helped us to optimize the MySQL settings, and I would assume they would have noticed that when they were digging around. I'm moving to a new, larger, and better server this evening. However, we have not maxed out on bandwidth and the server load has never shown anything disturbing. Perhaps the new server will solve it. I have a bad feeling that the site needs to be re-programmed into better PHP code. I've also wondered about Zend PHP Optimizer. Does anyone have any experience with that which they are willing to share? Link to comment https://forums.phpfreaks.com/topic/38240-performance-issues/#findComment-183179 Share on other sites More sharing options...
redarrow Posted February 13, 2007 Share Posted February 13, 2007 i use the zend optimizer it is grate try it it's free that will speed all things up. are you shure it not picture related from the index page or a header pic size post your url ok. Link to comment https://forums.phpfreaks.com/topic/38240-performance-issues/#findComment-183184 Share on other sites More sharing options...
bgetting Posted February 13, 2007 Author Share Posted February 13, 2007 The URL to the site that is showing issues is: Practical eCommerce It has been moved to a better server and showing improvement, but the problem needs to be fixed. Any increases in traffic will probably make the problem show up again. Link to comment https://forums.phpfreaks.com/topic/38240-performance-issues/#findComment-183407 Share on other sites More sharing options...
o3d Posted February 13, 2007 Share Posted February 13, 2007 Is the site hosted on a windows or unix box? Secondly, your table sizes does have a big impact when inserting data and updating the index for each insert. Processing power and memory play a big role here, but personally i have noted on a windows (2000 server) that mysql is not that resource intensive. Make sure your indexes are properly created and created on the correct fields which are used mostly in "where", "in" and "order" by clauses. Hope this helps. Link to comment https://forums.phpfreaks.com/topic/38240-performance-issues/#findComment-183415 Share on other sites More sharing options...
bgetting Posted February 13, 2007 Author Share Posted February 13, 2007 Linux box. I'm not too worried about the Indexes, asthe home page (for example) does not INSERT or UPDATE data. I'm almost positive that the issue is sluggish processing of the PHP code, but I want to be absolutely sure. Any input as to where someone goes to get their application cleaned up? Link to comment https://forums.phpfreaks.com/topic/38240-performance-issues/#findComment-183666 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.