Portfolio of the week - 2007

[Rob]

You'd think the forum software would have a way around that problem.

It should, and MySQL, the DB software vBulletin uses, supports indexing too, which, if implemented properly, would avoid the necessity of having to scan the entire table created by a long thread. I wonder if them vBulletin boys have done that or are working on it.

[riverbabe]

Buy DE long please. River

[IIC]

Karel...that's not where I usually have the problem...The slow load mostly happens to me...when I visit and then click DISCUSSION.

[skiracer]

Couldn't it be in vBulletin's server's and the load on them at different times of the day. I have noticed it is running slower across the board. At times different operations take longer than others is another item that I've noticed. I don't see where anything has changed on my side as the several other sites I have up and running are all operating at their usual Comcast Broadband speeds.

[Karel]

Thanks for the feedback so far. Two points: vBulletin is just the software we use (on our own server), and we have really, really long threads. 13 have over 1000 posts; the POTW thread had over 10,000 posts. It may not even be a question of vBulletin being optimised enough (I fear other software would have broken down already), but of mySQL being optimised enough for this kind of job.

And our server is not a dedicated job, it is some virtual server space, as far as I know.

Please also mention it when the split did help (somewhat).

Regards,

Karel

[peanuts]

Thanks for the feedback so far. Two points: vBulletin is just the software we use (on our own server), and we have really, really long threads. 13 have over 1000 posts; the POTW thread had over 10,000 posts. It may not even be a question of vBulletin being optimised enough (I fear other software would have broken down already), but of mySQL being optimised enough for this kind of job.

And our server is not a dedicated job, it is some virtual server space, as far as I know.

Please also mention it when the split did help (somewhat).

Regards,

Karel

Karel, great work! I have noticed a difference in load speed.

One problem, however... when you closed the old thread, you also closed the ability to edit posts. The contest description, rules, player's current positions, and the yearly results are frozen... I am unable, for example, to edit the "current player holdings" post to reflect Riverbabe's trade into DE.

Could you possibly grab those posts and move them to this thread? Otherwise, I've got my work cut out for me...

Thanks for all the hard work you do, I hope it doesn't distract you from the fun

[Karel]

Hi Peanuts,

glad it works for you. I moved the posts; your signature links still work.

Regards,

Karel

[skiracer]

I was talking about the speed of things before you made the split. It does seem to be quicker after the split. You do a great job for us Karel. Thanks.

[peanuts]

woah boy, simma dahn now

sell APKT

CA$H money

[IIC]

out MR...in DAKT...IIC

[spikefader]

Buy DE long please. River

Nice!

[spikefader]

sell APKT

CA$H money

Given the TA, imo that was a great result - congrats!

[riverbabe]

Nice!

Would'a been nicer if I'd got in earlier!

[peanuts]

putting the CA$H to use

buying IHR right here

[peanuts]

Hi Peanuts,

glad it works for you. I moved the posts; your signature links still work.

Regards,

Karel

Thank you for doing that, Karel! You da man, HUGE dude!