Game Development Community

Still cant search body of post

by J Brown · in Torque Game Engine · 11/18/2001 (2:07 am) · 7 replies

GG guys...

I'm sure you already know that the "search body text" isn't working in the advanced search. I really hope you guys plan to fix this sometime soon?

I've found it to be a huge help on other forums, and I'm sure users here are not getting all the useful results they would if it were enabled.

I currently find myself having to dig, thread by thread, post by post, to find relevant information because the subject is not really adequate for a search in many cases (threads stray off topic, etc).

Thanks.

#1
11/18/2001 (2:42 am)
yep, you defenetly need to look into this.
I myself am searching for some topics I read once, but can't seem to find them becuase they have irrelevant titles.
#2
11/18/2001 (8:37 am)
Last I read here it is not ever going to happen due to the excessive search times required to go thru all the threads.
#3
11/18/2001 (4:14 pm)
Heh..

Developers are going to need a good search capability here, that's just all there is to it. I'm sure GG knows that, but I thought I'd post a reminder.
#4
11/18/2001 (7:23 pm)
Maybe if they index the threads every few hours? Would make the search faster and cut down on db strain. Search will be necessary in the future (a little bit now) since lots of questions get answered, they get asked again, and it's difficult to look up old info.
#5
11/24/2001 (2:46 am)
Yeah, that sounds like a good option.

I guess it depends which database (if any) they're using, but I heard in another thread that it was taken out because of trouble with the SQL query.

If thats true, I'd offer some time to get the query right. I've had tons of experience with SQL and stored procedures... Let me know GG.
#6
11/25/2001 (9:08 am)
It was taken out because of the performance; everytime someone would run a search, the server would lock up for about 20 secs :) That was, as I'm sure you'd agree, unaccetable performance. Obviously something wrong with our SQL query, or maybe we do need some intermediate tables. It just hasn't been on our high priority list to look at. It would be nice to get going again though.
ps. We're using mySQL.
pps. If someone does want to take a look at it, send me some email.
#7
12/05/2001 (4:54 pm)
Tim-> I just e-mailed you. I'd be more than happy to take a look at it, I feel having the option enabled again would make it worth my time...

Let me know how you wish to proceed.