rootbear75 Posted April 17, 2007 Report Posted April 17, 2007 I have noticed recently, that the quotes database is abnormally slow, sometimes taking up to a minute to load any quotes page (latest, random, etc.)I thought this had to do with the move over to hosting FC and SSDL on the same server, but i thought it would have worked itself out by now.Just wanted to let you guys know, cause before the move, it went a lot faster.
Shock Posted April 18, 2007 Report Posted April 18, 2007 Ahh, yes! The anticipation kills me. !@#$%^&* thing takes at least 45 seconds to load any page but the main one.
»Maverick Posted April 18, 2007 Report Posted April 18, 2007 Maybe because of the total rewrite by Dustpuppy?
rootbear75 Posted April 19, 2007 Author Report Posted April 19, 2007 Maybe because of the total rewrite by Dustpuppy?you mean the design?no, it was working fine... like i said, before the server switch
PoLiX Posted April 19, 2007 Report Posted April 19, 2007 Was working fine even after it. Was only in past few days it began acting up, cause was fine a week ago.
Shock Posted April 19, 2007 Report Posted April 19, 2007 Polix, it's been happening way longer than you think.
»1587200 Posted April 19, 2007 Report Posted April 19, 2007 Yeah, for about the past two months or so, when I click on "Latest" it takes forever. I usually open it in a new tab and continue browsing the internet until it finishes.
Smong Posted April 19, 2007 Report Posted April 19, 2007 Was working fine even after it. Was only in past few days it began acting up, cause was fine a week ago.Polix, it's been happening way longer than you think.Agreed.
rootbear75 Posted April 19, 2007 Author Report Posted April 19, 2007 Yeah, for about the past two months or so, when I click on "Latest" it takes forever. I usually open it in a new tab and continue browsing the internet until it finishes.i do that too
larrythehamster Posted April 20, 2007 Report Posted April 20, 2007 Yeah, for about the past two months or so, when I click on "Latest" it takes forever. I usually open it in a new tab and continue browsing the internet until it finishes.i do that too The wonders of porn... Time killing ftw
»Maverick Posted April 25, 2007 Report Posted April 25, 2007 Smong, you are a quotes admin Already know what's causing it?
»D1st0rt Posted April 25, 2007 Report Posted April 25, 2007 None of the admin pages take forever to load, as far as I can tell it's just when you try to view the actual quotes. might be a really long db query or something
»CypherJF Posted April 28, 2007 Report Posted April 28, 2007 Well someone fix it? Hopefully it's not polling all the quotes for each page, then selecting all the votes and then limiting the number needed to display on the page. Shouldn't be too hard to figure out how bad the queries are if the script was written properly.
»Dustpuppy Posted May 1, 2007 Report Posted May 1, 2007 Seems to be fixed. Thanks, whoever.The problem was caused by the new system that hides the voting links for quotes you've already voted for. I just got back from holiday yesterday so I've not had time to do a proper fix, for now I've just made the links show for all the quotes. I did notice that the quote lists were loading somewhat slowly after the change though, so I made a few other changes, including:I've changed the number of quotes per page to 25, down from 50.I'm experimenting with moving the name highlighting to javascript. This has drasticallly reduced page sizes but you won't see any highlighting until the page has fully loaded.I'll try to get a proper fix for the voting links done later this week, as well as a few other things. As always, comments/suggestions welcome.
rootbear75 Posted May 1, 2007 Author Report Posted May 1, 2007 yea its (much) better now. you can close this topic.
»Maverick Posted May 2, 2007 Report Posted May 2, 2007 Thanks Dustpuppy If anyone want to make a suggestion for the quotes, PM Dustpuppy or post a new topic. [Closed]
Recommended Posts