Searching Forums Disabled!!

[wey97]

When i try to search the forums, why do I get this message?!

vBulletin Message
Sorry. The search function has been disabled by the administrator.

Oh, and how do you get an image below your username in posts?

[Ed Sullivan]

You get that message because right now, the search tends to spike the server... at least when your return 5800 results.

And it's the avatar part of your options.

[wey97]

I searched the topic before and returned no where near 5800 results. More like 500 or so.

[wey97]

When will the server be able to handle it?

[wey97]

I just want to let you know that this is frustrating as hell.

[Ed Sullivan]

Dude, calm down.

I don't have access to the scripts here - I only have access to the copies on the dev board.

And just because you ran a search and it only returned 500 posts, doesn't mean there isn't one that returned 5800.

The server won't be able to handle it until the code is changed and John makes the changes here. I wouldn't expect that to happen until later today. Assuming we work it out

[wey97]

I'm calm, DUDE.

I agree with wey97, not having search is getting frustrating! I'm looking for a post made a few days ago by someone and do you think I can find it?

Anyway, the new format looks good, my compliments.

[wey97]

Yeah, the new layout looks good.
The search is still not working though.

[davem]

This site helps me immensely... but I have found that with no search feature, finding something is like the old needle/haystack addage.

When will the search be working again?

[wey97]

I agree. They said it would be fixed days ago.

Originally posted by wey97
I agree. They said it would be fixed days ago.

You guys really need to lay off of it.

The search has been "fixed". John turned it off just in case it still had any lingering problems and he was going to turn it back on. Something came up and he is away at the moment so that is why it is still off.

[barrk]

Thanks for fixing this.....you guys are GREAT!

[John]

Yup - they're back online now. Not all the posts have been indexed yet, so they are being done at the moment. If things seem a little slower, that is probably the reason.

All posts since vbulletin 2 was installed have been indexed, and about 20% of those from previously posted too.

John

[Benjamin]

what do you mean indexed??

don't you just have to search through the messages?

$res = $DB_Site->query("SELECT from post where pagetext='%$searchboxname%');

sorry if thats a stupid question... I don't know much about MySQL at the moment..

[barrk]

Originally posted by Benjamin
$res = $DB_Site->query("SELECT from post where pagetext='%$searchboxname%');

Wouldn't that be like instead of = ?

$res = $DB_Site->query("SELECT from post where pagetext like'%$searchboxname%');

[Ed Sullivan]

No, the search method has completely changed. THAT method is the one that tends to kill servers.

I had John stop indexing for a moment and ran a search that returned 16000 posts in about 2.2 seconds.

[barrk]

Cool!!!

[Ed Sullivan]

Yes, it would be LIKE, but we actually used INSTR before because it was faster anyway. (It's case sensitive though)

[barrk]

How do you handle the case sensitivity..change everything to Ucase then do the instr check??

[Benjamin]

first.... Oops!! I'm not thinking too much at the moment... I forgot all about 'like'...

second...

Originally posted by Ed Sullivan
No, the search method has completely changed. THAT method is the one that tends to kill servers.

I had John stop indexing for a moment and ran a search that returned 16000 posts in about 2.2 seconds.

If you're not doing it like that... then how??

I can't seem to think of any other way it could be done....
well, I can, but they are completely not practical, and I would think they would put even more stress on the server....

Thanks John for fixing search. I find it really useful. Keep up the good work.

[Ed Sullivan]

Originally posted by barrk
How do you handle the case sensitivity..change everything to Ucase then do the instr check??

Both methods store all the data in all lower case. But "pattern matching" (LIKE is just a simple regex) is incredibly slow. Now have it look through the text indexes of 50000 threads, and... well, I'm sure you can see the problem there.

Now it works with integers and a simple relationship. I'm not going to go into details though - I'll leave the up to John.