My Little Pony - Friendship is Magic (part 2)

**Anakonda** · 2011-09-28, 04:55 PM

I updated the OP a bit, with numbers and a few names.
If you want some changes to it, let me know!

**Solazz** · 2011-09-28, 04:55 PM

This looks like a nice thread. Rainbow Dash is best pony. (Until I have a different favorite next week.)

**pickles** · 2011-09-28, 04:55 PM

Originally Posted by Sunshine

Explanation for those who end up missing it in the other thread:

Enjoy the freshness!

Sunshine are you selling deodorant now?

Or feminie hygene products.

**Mixup** · 2011-09-28, 04:55 PM

Originally Posted by Sunshine

Explanation for those who end up missing it in the other thread:

Enjoy the freshness!

Thanks muchly for the heads up, Sunshine.

Come on, ponies! Let's get another 100k posts all up in hurr! <3

**Sno** · 2011-09-28, 04:56 PM

Originally Posted by Sunshine

Explanation for those who end up missing it in the other thread:

Enjoy the freshness!

If we limited to 1k posts... the fun section would be doomed! Te-hehe

**Diftraku** · 2011-09-28, 04:56 PM

Being abruptly cut off from the old thread, this shall go here:

Originally Posted by Powerogue

I don't usually read fanfiction, but when I do I notice the actual show incorporating it.

*snip*

is this a sign that they're incorporating fan fiction ideas into the show, or that I'm dangerously obsessed enough to notice coincidences like this?

It's the herdmind, I tells ye!

Originally Posted by Anakonda

That..... was epic.

Are there any other similar epics on youtube that you lot know about?

See Makkon's profile on youtube, he has some awesome songs over there.

Originally Posted by Sunshine

No, that post is from 2002, and it's irrelevant here. I just spoke with a vBulletin expert who confirmed that it starts getting really bad after 100k posts. There's legacy code with a bad query and a bunch of math to determine pagination.

*snip*

Anyway, see you all in the new thread; feel free to ask more questions there.

I'm assuming Vbulletin has built-in support for APC/Memcached? If not then please do tell me Vbulletin has some sort of caching system in place.
The page count shouldn't be that bad, really. Assuming the board is doing it correctly and doing a query along the lines of SELECT * FROM posts WHERE `threadID` = '893666' AND `deleted` = '0' LIMIT 0, 20; (I'm assuming a lot of things here and doing it mostly in pseudo SQL, for example: the limit should start from last post ID on previous page, instead of all the posts and assuming threadID is an index along with post state, using deleted as a on/off state since I don't remember how it worked in phpBB). Then again, MySQL is just silly DB platform...

**Anakonda** · 2011-09-28, 04:57 PM

Originally Posted by Sno

If we limited to 1k posts... the fun section would be doomed! Te-hehe

Haha so true. They would have to rename whole forum to "Ponies & maybe other stuff" XD

**kortin** · 2011-09-28, 04:57 PM

Well thats rather upsetting. Oh well.

**Alaitoc** · 2011-09-28, 04:57 PM

Originally Posted by Affixiation

bkaws is nise show an has many famihlee valyews

but ponys r pink n kawaii were is adult humur liek famly guy

- Mod edit: Please don't troll. It doesn't matter if you're joking or not, some people find it offensive. -

**Mixup** · 2011-09-28, 04:57 PM

Well, one good thing came from the alpha-thread being closed.

My place on top is now set in stone for all eternity!

**Caumen** · 2011-09-28, 04:57 PM

Page two have been flipped, and we are only just starting!

**Whiskra** · 2011-09-28, 04:58 PM

My Little Pony: Friendship is Magic is dead, long live My Little Pony: Friendship is Magic (part 2)

**Anakonda** · 2011-09-28, 04:58 PM

Originally Posted by Diftraku

I'm assuming Vbulletin has built-in support for APC/Memcached? If not then please do tell me Vbulletin has some sort of caching system in place.
The page count shouldn't be that bad, really. Assuming the board is doing it correctly and doing a query along the lines of SELECT * FROM posts WHERE `threadID` = '893666' AND `deleted` = '0' LIMIT 0, 20; (I'm assuming a lot of things here and doing it mostly in pseudo SQL, for example: the limit should start from last post ID on previous page, instead of all the posts and assuming threadID is an index along with post state, using deleted as a on/off state since I don't remember how it worked in phpBB). Then again, MySQL is just silly DB platform...

**Mixup** · 2011-09-28, 04:59 PM

Originally Posted by Caumen

Page two have been flipped, and we are only just starting!

LET'S GET PONY IN HERE.

Heh

---------- Post added 2011-09-29 at 02:59 AM ----------

Reposting for great win.

**DasHuntard** · 2011-09-28, 05:00 PM

Originally Posted by Alaitoc

but ponys r pink n kawaii were is adult humur liek famly guy

yup trolling

**Mixup** · 2011-09-28, 05:01 PM

---------- Post added 2011-09-29 at 03:01 AM ----------

Originally Posted by DasHuntard

yup trolling

Hehe. <3

**DasHuntard** · 2011-09-28, 05:01 PM

Originally Posted by Mixup

Well, one good thing came from the alpha-thread being closed.

My place on top is now set in stone for all eternity!

I came in second again,
way to go life,

**Ravlon** · 2011-09-28, 05:02 PM

Greetings, my ponies!

**isi** · 2011-09-28, 05:02 PM

oooh all new thread... *sniff*...uuh... smells strange

**Mixup** · 2011-09-28, 05:02 PM

Damn. It's gonna take me forever to get back up to 10k posts.

Thread: My Little Pony - Friendship is Magic (part 2)

Thread Tools

Posting Permissions