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. http://i157.photobucket.com/albums/t54/badgersocks/FHTG/FHTG%20-%20redone%20shizniz/tgmember11.pngrootbear75> here is me nude <spoiler tag: Pervert... how many of you actually clicked this?>Samapico> I actually clicked the spoiler before reading what it was Corey> I clicked it cause i read what sama said first. darkreb0rn> I clicked it because I wanted to see you naked... rootbear75> O.o __________________________________2:IdleRPG> Mr Snuffleluphagus walked face-first into a tree. This terrible calamity has slowed them 0 days, 00:01:22 from level 18.2:rootbear75> for fucks sake...
★ CRe Posted April 18, 2007 Report Posted April 18, 2007 yea its slow -CReSSCC Desert Storm OwnerB.O.P. - Alive and running till the end of continuum. 4:L.C.> @Cre I am wearing.. THIS https://secure.wikimedia.org/wikipedia/en/wiki/Anti-rape_device4:L.C.> Dick untouchable, and my ass will shred your cock http://i44.tinypic.com/kf18ww.png
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. http://img361.imageshack.us/img361/3600/lolrootxs2.pngSHOCK> polix audry said she would fuck u if u lived in quebecPoLiX> eh, if she's a frenchy, no go---------------------------Aarbear> and btw, I dun think swear words are bad... they are just manmade words afterall Aarbear> bible doesn't say to not say fuck---------------------------help: (BrAnDnew) (dtq): KNIGHT IS A COCK SUCKING ######---------------------------Makavelii> for soem reason i think pussy will taste like vinigar/salt/starburst
★ Maverick Posted April 18, 2007 Report Posted April 18, 2007 Maybe because of the total rewrite by Dustpuppy? Check out your zone population statistics at stats.sshq.net! MaverickSubspace Statistics AdministratorRetired SSCU Trench Wars Super ModeratorTWCore Coordinator Administrator
★ CRe Posted April 18, 2007 Report Posted April 18, 2007 yea i guess its cause of that -CReSSCC Desert Storm OwnerB.O.P. - Alive and running till the end of continuum. 4:L.C.> @Cre I am wearing.. THIS https://secure.wikimedia.org/wikipedia/en/wiki/Anti-rape_device4:L.C.> Dick untouchable, and my ass will shred your cock http://i44.tinypic.com/kf18ww.png
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 http://i157.photobucket.com/albums/t54/badgersocks/FHTG/FHTG%20-%20redone%20shizniz/tgmember11.pngrootbear75> here is me nude <spoiler tag: Pervert... how many of you actually clicked this?>Samapico> I actually clicked the spoiler before reading what it was Corey> I clicked it cause i read what sama said first. darkreb0rn> I clicked it because I wanted to see you naked... rootbear75> O.o __________________________________2:IdleRPG> Mr Snuffleluphagus walked face-first into a tree. This terrible calamity has slowed them 0 days, 00:01:22 from level 18.2:rootbear75> for fucks sake...
🜲 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. SSForum.net - September 01, 2002 - Rowen (SSDownloads.Com), PoLiX (SSCentral.Com), and Cyberise (Subspace.Net)
Shock Posted April 19, 2007 Report Posted April 19, 2007 Polix, it's been happening way longer than you think. http://img361.imageshack.us/img361/3600/lolrootxs2.pngSHOCK> polix audry said she would fuck u if u lived in quebecPoLiX> eh, if she's a frenchy, no go---------------------------Aarbear> and btw, I dun think swear words are bad... they are just manmade words afterall Aarbear> bible doesn't say to not say fuck---------------------------help: (BrAnDnew) (dtq): KNIGHT IS A COCK SUCKING ######---------------------------Makavelii> for soem reason i think pussy will taste like vinigar/salt/starburst
★ 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 http://i157.photobucket.com/albums/t54/badgersocks/FHTG/FHTG%20-%20redone%20shizniz/tgmember11.pngrootbear75> here is me nude <spoiler tag: Pervert... how many of you actually clicked this?>Samapico> I actually clicked the spoiler before reading what it was Corey> I clicked it cause i read what sama said first. darkreb0rn> I clicked it because I wanted to see you naked... rootbear75> O.o __________________________________2:IdleRPG> Mr Snuffleluphagus walked face-first into a tree. This terrible calamity has slowed them 0 days, 00:01:22 from level 18.2:rootbear75> for fucks sake...
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 larrythehamster [ste]SSCU 17th Parallel Sysop http://i41.tinypic.com/2pq3ymg.jpg
★ Maverick Posted April 25, 2007 Report Posted April 25, 2007 Smong, you are a quotes admin Already know what's causing it? Check out your zone population statistics at stats.sshq.net! MaverickSubspace Statistics AdministratorRetired SSCU Trench Wars Super ModeratorTWCore Coordinator Administrator
★ 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 _UU___UU__SSSSS____AAA____UU___UU__SSSSS____AAA____UU___UU_SS_______AAAAA___UU___UU_SS_______AAAAA___UU___UU__SSSSS__AA___AA__UU___UU__SSSSS__AA___AA__UU___UU______SS_AAAAAAA__UU___UU______SS_AAAAAAA___UUUUU___SSSSS_AA____AA___UUUUU___SSSSS_AA____AAJ.C. Dento> prime example of why america will never be a world super power.Moscato> d1 is mad he will never have a job outside subspaceI can't see this because I turned signatures off. ps VT
★ 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. Owner/Operator of Omega Fire
Shock Posted May 1, 2007 Report Posted May 1, 2007 Seems to be fixed. Thanks, whoever. http://img361.imageshack.us/img361/3600/lolrootxs2.pngSHOCK> polix audry said she would fuck u if u lived in quebecPoLiX> eh, if she's a frenchy, no go---------------------------Aarbear> and btw, I dun think swear words are bad... they are just manmade words afterall Aarbear> bible doesn't say to not say fuck---------------------------help: (BrAnDnew) (dtq): KNIGHT IS A COCK SUCKING ######---------------------------Makavelii> for soem reason i think pussy will taste like vinigar/salt/starburst
★ 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. http://quotes.sscentral.com/banner.gif
rootbear75 Posted May 1, 2007 Author Report Posted May 1, 2007 yea its (much) better now. you can close this topic. http://i157.photobucket.com/albums/t54/badgersocks/FHTG/FHTG%20-%20redone%20shizniz/tgmember11.pngrootbear75> here is me nude <spoiler tag: Pervert... how many of you actually clicked this?>Samapico> I actually clicked the spoiler before reading what it was Corey> I clicked it cause i read what sama said first. darkreb0rn> I clicked it because I wanted to see you naked... rootbear75> O.o __________________________________2:IdleRPG> Mr Snuffleluphagus walked face-first into a tree. This terrible calamity has slowed them 0 days, 00:01:22 from level 18.2:rootbear75> for fucks sake...
jacob hunter! Posted May 1, 2007 Report Posted May 1, 2007 need a post in for 10k though first http://i114.photobucket.com/albums/n243/dooshberry/attraction.jpghttp://img503.imageshack.us/img503/7196/lolrootyl9.png
rootbear75 Posted May 1, 2007 Author Report Posted May 1, 2007 what? http://i157.photobucket.com/albums/t54/badgersocks/FHTG/FHTG%20-%20redone%20shizniz/tgmember11.pngrootbear75> here is me nude <spoiler tag: Pervert... how many of you actually clicked this?>Samapico> I actually clicked the spoiler before reading what it was Corey> I clicked it cause i read what sama said first. darkreb0rn> I clicked it because I wanted to see you naked... rootbear75> O.o __________________________________2:IdleRPG> Mr Snuffleluphagus walked face-first into a tree. This terrible calamity has slowed them 0 days, 00:01:22 from level 18.2:rootbear75> for fucks sake...
★ 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] Check out your zone population statistics at stats.sshq.net! MaverickSubspace Statistics AdministratorRetired SSCU Trench Wars Super ModeratorTWCore Coordinator Administrator
Recommended Posts