MySQL request times out

  • tastysite
  • Proficient
  • Proficient
  • User avatar
  • Joined: Apr 09, 2008
  • Posts: 349
  • Loc: Brighouse, West Yorkshire, England
  • Status: Offline

Post June 26th, 2009, 10:51 am

On my site I have a MySQL daterbace but when getting data from it the site runs slow, I can add data to it and even request some parts (in my case that titles and primary keys) but as so as I try to access the actual page it runs slow and then times out, because I can do all the rest in a matter of seconds I think it must be my coding. I just wanted to know can coding alone slow a site down?
^__^
  • Anonymous
  • Bot
  • No Avatar
  • Joined: 25 Feb 2008
  • Posts: ?
  • Loc: Ozzuland
  • Status: Online

Post June 26th, 2009, 10:51 am

  • UPSGuy
  • Lurker ಠ_ಠ
  • Web Master
  • User avatar
  • Joined: Jul 25, 2005
  • Posts: 2735
  • Loc: Nashville, TN
  • Status: Offline

Post June 26th, 2009, 10:54 am

Absolutely. The way you approach your code can make a world of difference in performance and proper connection resolution.
I'd love to change the world, but they won't give me the source code.
  • Bogey
  • Bogey
  • Genius
  • User avatar
  • Joined: Jul 14, 2005
  • Posts: 8211
  • Loc: USA
  • Status: Offline

Post June 26th, 2009, 11:16 am

If you like, you can post the code here and we could try to help you find the problem that slows down the site so much.
"Bring forth therefore fruits meet for repentance:" Matthew 3:8
  • Rabid Dog
  • Web Master
  • Web Master
  • User avatar
  • Joined: May 21, 2004
  • Posts: 3229
  • Loc: South Africa
  • Status: Offline

Post June 30th, 2009, 3:38 pm

Make sure you have the correct data structures in place. The next thing to look for is prehaps some sort of recursive loop or some sort of iffy condition test.
Watch me grow

Post Information

  • Total Posts in this topic: 4 posts
  • Users browsing this forum: No registered users and 112 guests
  • You cannot post new topics in this forum
  • You cannot reply to topics in this forum
  • You cannot edit your posts in this forum
  • You cannot delete your posts in this forum
  • You cannot post attachments in this forum
 
 

© 2011 Unmelted, LLC. Ozzu® is a registered trademark of Unmelted, LLC.