Fixing up some perf issues | The Coffeehouse

Sampy
This will be the sixth time we have destroyed it and we have become exceedingly efficient at it

I'm doing a little database sluthing now to help out with some misbehaving queries.

As I type this, I'm adding an index. Let's see how C9 handles while I'm doing that Smiley

mVPstar
I'm white because I smelt an onion.

Kaboom!

Sampy
This will be the sixth time we have destroyed it and we have become exceedingly efficient at it

My fix is related to search so it appears that's the only thing that doesn't work.

Go CREATE INDEX, go! (The table in question has 21 million rows and the query was doing a full table scan)

mVPstar
I'm white because I smelt an onion.

Search seems faster, that it does. Smiley

Sampy
This will be the sixth time we have destroyed it and we have become exceedingly efficient at it

I know that user searching should be faster but I don't know about other kinds of searches. I've got a table with the results of a trace that Orcsweb did for us and I'm sorting it by Duration and going down the list.

I'll blog all the details on this later. SQL optimization is a strange kind of fun.

W3bbo
The Master of Baiters

Sampy wrote:
My fix is related to search so it appears that's the only thing that doesn't work.

Go CREATE INDEX, go! (The table in question has 21 million rows and the query was doing a full table scan)

21 million rows... that would be the table holding information about who read what thread, right?

littleguru
<3 Seattle

I have only 6030 posts. I thought it were more...

Btw. nice to have search back and working Smiley

littleguru
<3 Seattle

Now what about creating a search provider for Channel 9 and embeding it into the website's header? Should be done in 10 minutes and would be nice to have Smiley

W3bbo
The Master of Baiters

littleguru wrote:
I have only 6030 posts. I thought it were more...

Btw. nice to have search back and working

My postcount can beat up your postcount:

12,839

Woo!

littleguru
<3 Seattle

W3bbo wrote:

littleguru wrote: I have only 6030 posts. I thought it were more...

Btw. nice to have search back and working

My postcount can beat up your postcount:

12,839

Woo!

There are a lot beating me Tongue Out

But your post count is extraordinaire high.

mVPstar
I'm white because I smelt an onion.

1,967.

So, that means I'm not a C9 geek like the two of you. Tongue Out

Sampy
This will be the sixth time we have destroyed it and we have become exceedingly efficient at it

It's a table called SearchBarrel.

The ghost of Community Server still haunts these servers...

CyberGeek
Kittens in fishbowls are cute

At 230 posts (including this one) I'm not exactly a frequent poster. Or something.

W3bbo
The Master of Baiters

Sampy wrote:
It's a table called SearchBarrel.

The ghost of Community Server still haunts these servers...

Elaborate

littleguru
<3 Seattle

CyberGeek wrote:
At 230 posts (including this one) I'm not exactly a frequent poster. Or something.

you can have 20,000 posts of bs or 200 very good one. What is better? Smiley

Sven Groot
My name has 9 letters. Coincidence? I think not...

7005 posts of high quality content! Tongue Out

Dr Herbie
Horses for courses

Get a proper job, you bunch of layabouts! Wink

Herbie

W3bbo
The Master of Baiters

littleguru wrote:

CyberGeek wrote:At 230 posts (including this one) I'm not exactly a frequent poster. Or something.

you can have 20,000 posts of bs or 200 very good one. What is better?

Let's make a quick comparison:

There's Mike Dimmick with few posts, but they're all +5 and make us want his babies.

Then there's my posts, loads of 'em, but mostly cynical bashings of whatever anyone else is posting.

But 3 years down the time and how many people know me than they know Mike?

It proves that fame is not necessarily a function of your intrinstic qualities, but how much you spam. Previous examples include Britney Spears, System of a Down, and Paris Hilton.

AndyC

W3bbo wrote:

But 3 years down the time and how many people know me than they know Mike?

Yeah, but Mike hasn't posted in ages (sadly, as the man is a fountain of knowledge) and people tend to forget quickly in online forums. Especially as newer faces show up who have no idea about posters of the past.

Damn this whole transient internet culture thing....

Lloyd_Humph
If Blackberrys are addictive cellphones, Channel9 is the ultimate addictive website.

To be honest, before I signed up I lurked here a bit, reading into a couple of years back, to see how C9 had grown to see if I would fit in. It would appear that I settled in nicely Big Smile

AndyC

Lloyd_Humph wrote:
To be honest, before I signed up I lurked here a bit, reading into a couple of years back, to see how C9 had grown to see if I would fit in. It would appear that I settled in nicely

Yeah, but that's because you're a sensible, polite young man who follows generally recognized good behaviour for an online forum. Such beasts are few and far between. Wink

Lloyd_Humph
If Blackberrys are addictive cellphones, Channel9 is the ultimate addictive website.

AndyC wrote:

Lloyd_Humph wrote: To be honest, before I signed up I lurked here a bit, reading into a couple of years back, to see how C9 had grown to see if I would fit in. It would appear that I settled in nicely

Yeah, but that's because you're a sensible, polite young man who follows generally recognized good behaviour for an online forum. Such beasts are few and far between.