TranceAddict Forums (www.tranceaddict.com/forums)
- Canada - Toronto & Southern Ont.
-- Why is this site so slow?
Pages (2): [1] 2 »

Why is this site so slow?

No offence to swamper or anyone else involved with the site, but do you find this site might work quickly for say 5-10 mins then COMPLETELY come to a hault. Takes FOREVER to load topics, make a post and just to do about everything else here.

I do not run into this problem on other boards.

It drives me up the wall

From my understanding it happens everytime someone searches the database for a common word, ie if someone searches for the word "trance" or "Music" it comes to a crawl....so ive heard

Ampz

Yeah, or "butt"

Re: Why is this site so slow?

quote:

Originally posted by Euphorica No offence to swamper or anyone else involved with the site, but do you find this site might work quickly for say 5-10 mins then COMPLETELY come to a hault. Takes FOREVER to load topics, make a post and just to do about everything else here. I do not run into this problem on other boards. It drives me up the wall

Because you touch yourself at night.

Re: Re: Why is this site so slow?

quote:

Originally posted by EvilTree Because you touch yourself at night.

+1 and one of the greatest Family Guy quotes ever.

you need to fire off some knuckle children daily

its cos swamper actually spanks the monkey whenever its slow...see..TA is hooked into his brain so if his brain is too busy with one aspect, it devotes all resources there, theryby making TA, teh s10w

quote:

Originally posted by El Kay Dee its cos swamper actually spanks the monkey whenever its slow...see.. Swamper uses the same server TA is running on to download pr0n.

Fixed for more funniness/realism.

quote:

Originally posted by Cosmic Fur Fixed for more funniness/realism.

ooooh...ur SO gonna get a beating

Try changing the spark plugs

TURN IT UP!

Find the TOTA speed dial, and just turn up the speed until it is fast enough for you.

quote:

Originally posted by DJ_Ampz From my understanding it happens everytime someone searches the database for a common word, ie if someone searches for the word "trance" or "Music" it comes to a crawl....so ive heard Ampz

I've often wondered why you can't search user names?

quote:

Originally posted by Mr. Furious I've often wondered why you can't search user names?

..because it is as intensive as searching for a common word (like "trance" or "tiesto").

Searches are most efficient when they include terms that are uncommon, like "Tiesto toronto december" or "republik dumonde" .. etc.

Can't you make it so that the searches have a much lower priority on the server's CPU than replies and page views?

quote:

Originally posted by Cosmic Fur Can't you make it so that the searches have a much lower priority on the server's CPU than replies and page views?

Unfortunately, no. It locks certain database tables during the search and then all the other queries just wait in queue - I'd set it to dump any search that doesn't return a result within 20 seconds but you can't do that with mysql.

MySQL blah blah ... Text files dammit!

quote:

Originally posted by Swamper Unfortunately, no. It locks certain database tables during the search and then all the other queries just wait in queue - I'd set it to dump any search that doesn't return a result within 20 seconds but you can't do that with mysql.

Oh, I see the picture now. Yeah, no easy way of getting around that, except maybe creating two identical databases, one for searching and one fo browsing, but that's a retarded way of doing it.

quote:

Originally posted by Cosmic Fur Oh, I see the picture now. Yeah, no easy way of getting around that, except maybe creating two identical databases, one for searching and one fo browsing, but that's a retarded way of doing it.

Actually it is a smart way, I could do it across two servers - the problem lies here:

DB Server 1 - master - has all the current forum data
DB Server 2 - slave - has older version of the forums (used for search)

Now you're on DBServer1, if I throw you over to DBServer2 for the search then it has to talk back to DBServer1 with whatever it finds - the problem being that what it sends back is uncompressed - and considering how many searches are done here a day that is a ton of wasted bandwidth.

Alternative -> Allow you to request a search from here over to DBServer2 and have the results fed back to you from a web server running on DBServer2 - but - when you click a thread/post it would redirect you to DBServer1 so you could post your reply and everyone could see it

I tried having an alternate copy of the database on a whole other SCSI drive but while that helped in certain regards it was still tying things up while seeking it out

It'll be hectic for a bit.. eventually I need 2 or 3 opteron servers.. 1 for web.. 1 for forums and 1 for search.. with the ones for forums/search linked by crossover cable and with raid 10

(The built-in Mysql clustering doesn't work too well with Vbulletin/MyIsam tables)

>>> Outside of all this - the search page needs to be revamped and I need to throw a Google box in there too since it is much easier searching that way and half the forums are already in there.

nerds

more info then i needed to know

at least I understand why though.

it's never slow for me. (well very seldom). But I do get frustrated by the error page at certain times of the day.

Maybe it's not TA, it's your computer. You should stop downloading porn torrents the whole day.

ahahaa. Yeah I know. Thing is I dont have this issue on other boards I frequent, so the pr0n cant be creating that many issues

quote:

Originally posted by Euphorica ahahaa. Yeah I know. Thing is I dont have this issue on other boards I frequent, so the pr0n cant be creating that many issues

I suspect that very few other boards you frequent have close to 5 million posts - and those that do - restrict their search to registered users because they know it's a huge bottleneck.

Why not just filter out some of the really stupid search phrases?

I know it won't stop the problem, but it might at least reduce it somewhat. Just don't let people search for "trance" or "tiesto" or "armin", etc.

quote:

Originally posted by DigiNut Why not just filter out some of the really stupid search phrases? I know it won't stop the problem, but it might at least reduce it somewhat. Just don't let people search for "trance" or "tiesto" or "armin", etc.

do people actually do searches that are that retarded?

Powered by: vBulletin
Copyright © 2000-2021, Jelsoft Enterprises Ltd.