• Ask us about the forums v13 - Change it back!!
    3,005 replies, posted
[QUOTE=garry;30123545]It should be undeleted. I wanted to see whether it was that thread which was slowing the forums down. It was. VBulletin doesn't like big threads.[/QUOTE] Ban lmao pics
Also thank god he did, the forums were so incredibly slow
[QUOTE=LarparNar;30123565]So what is the thread lock limit going to be now?[/QUOTE]3500 it appears
Are we allowed to make new ones?
[QUOTE=TehWhale;30123581]3500 it appears[/QUOTE] I think it's 3000. Or maybe even lower.
It's 3,000. Of course you can remake the thread. It'll just get closed when it hits the 3,000 limit.
-snip Garryninja-
Any reason this happened with no new posts at all? [img]http://dl.dropbox.com/u/5483751/photos/2011-05-29_2124.png[/img]
I thought FP was going really slow, good to know you've figured out what it is! (Even if it was pretty obvious :v: )
Holy slowpunch until about 10 seconds ago garryman
Why don't big threads slow the forum down when they get closed?
[QUOTE=Orinkota;30126645]Why don't big threads slow the forum down when they get closed?[/QUOTE] Because people leave them i guess. Wait no that's not how it works, good question.
[QUOTE=garry;30123671]It's 3,000. Of course you can remake the thread. It'll just get closed when it hits the 3,000 limit.[/QUOTE] Why did things seem to work with the post limit being at 5000 before what changed?
[QUOTE=Zeke129;30127954]Why did things seem to work with the post limit being at 5000 before what changed?[/QUOTE] Budget cuts
Thanks for fixing the img_thumb'd images not being links garry.
[QUOTE=Chickens!;30126677]Because people leave them i guess. Wait no that's not how it works, good question.[/QUOTE] He actually deleted it for a bit. Anyone in it already downloaded the page, everyone else couldn't access it.
[QUOTE=garry;30123545]It should be undeleted. I wanted to see whether it was that thread which was slowing the forums down. It was. VBulletin doesn't like big threads.[/QUOTE] get more servers and/or don't use crap forum software. I cannot comprehend how it's possible that large threads are slower than small ones...
budget cuts
[QUOTE=Tangara;30129076]get more servers and/or don't use crap forum software. I cannot comprehend how it's possible that large threads are slower than small ones...[/QUOTE] Because it has to count a lot
[QUOTE=Jo The Shmo;30130272]Because it has to count a lot[/QUOTE]you have no idea how forum software works
[url]http://www.vbulletin.com/forum/showthread.php/116646-Large-threads-and-performance?p=739379&viewfull=1#post739379[/url] Except I don't know what I'm talking about so this could be completely wrong. but yeah apparently it calls count() on the database a lot and the sql server will be really laggy.
[QUOTE=Jo The Shmo;30130287][url]http://www.vbulletin.com/forum/showthread.php/116646-Large-threads-and-performance?p=739379&viewfull=1#post739379[/url] Except I don't know what I'm talking about so this could be completely wrong. but yeah apparently it calls count() on the database a lot and the sql server will be really laggy.[/QUOTE] That's not how databases work. Assuming garry has the thread_id column set as an index (which he should, everything should be indexed the fuck out of it), counting the number of posts where an indexed column equals a value should run pretty damn quickly. [editline]30th May 2011[/editline] and by quickly, i mean O(1) or O(log n) time
I like the new log out screen for the high traffic times. "Register or never come back"
thats not very new
Garry replaced the login page with that page when you try to do something you need to be logged in to do.
[QUOTE=Tangara;30131262]That's not how databases work. Assuming garry has the thread_id column set as an index (which he should, everything should be indexed the fuck out of it), counting the number of posts where an indexed column equals a value should run pretty damn quickly. [editline]30th May 2011[/editline] and by quickly, i mean O(1) or O(log n) time[/QUOTE] To use pagination it has to sort the thread. It takes longer to sort 5,000 posts than 1,000 posts.
Is there an API for the forum or something? I know I have little knowledge of databases and web things, but I think it'd be cool to design a program to view the forums in ASCII text.
happy mod big dumb american [img]http://www.kylandicatering.com.au/img/icons/cake3.png[/img]
Big Dumb Moderator time.
Congratulations BDA, have fun.
Sorry, you need to Log In to post a reply to this thread.