Author Topic: change in BBS Search function  (Read 450 times)

Offline clerick

  • Silver Member
  • ****
  • Posts: 1742
change in BBS Search function
« on: October 30, 2007, 06:26:04 PM »
Minor point, but I've been trying to search the forums for information on various planes and am having an issue with many since the designations are often three characters.  I will try a search using the planes "name" but they aren't  often called a lightning or wildcat et.c.

Offline whiteman

  • Platinum Member
  • ******
  • Posts: 4229
change in BBS Search function
« Reply #1 on: October 30, 2007, 06:27:43 PM »
I second this

Offline Redlegs

  • Silver Member
  • ****
  • Posts: 1151
Re: change in BBS Search function
« Reply #2 on: October 30, 2007, 06:35:43 PM »
I agree.
Resident Arizona Cardinals/Cincinnati Reds fan

Offline DoNKeY

  • Silver Member
  • ****
  • Posts: 1304
change in BBS Search function
« Reply #3 on: October 30, 2007, 06:41:03 PM »
Word up.



donkey
2sBlind

Offline Mr No Name

  • Silver Member
  • ****
  • Posts: 1835
change in BBS Search function
« Reply #4 on: October 30, 2007, 06:43:56 PM »
absofreakinlutely
Vote R.E. Lee '24

Offline Latrobe

  • Persona Non Grata
  • Platinum Member
  • ******
  • Posts: 5975
change in BBS Search function
« Reply #5 on: October 30, 2007, 06:52:07 PM »
Yes! :aok

I wanna be able to search the word "A" :D :lol

Offline clerick

  • Silver Member
  • ****
  • Posts: 1742
change in BBS Search function
« Reply #6 on: October 30, 2007, 06:57:53 PM »
Quote
Originally posted by Latrobe
Yes! :aok

I wanna be able to search the word "A" :D :lol


Obviously there needs to be SOME limitations, but there should be some work around for this.  I have tried searching "p-40" but the system ignores the "-" and sees it as 3 characters.

Offline JB73

  • Plutonium Member
  • *******
  • Posts: 8780
change in BBS Search function
« Reply #7 on: October 30, 2007, 07:57:51 PM »
this has been brought up before, and IIRC Skuzzy mentioned the problem inherent with having 3 character searching the database.

database queries can get really complicated, and I personally don't know enough about them, but I do know it is an issue of the search, and the size of the cache.

in the past there were problems with the scoring database, multiple searches taking enormous processing powers, and it messed with the arenas. why? the arenas have to send data to the scoring database, and if the arena server can't send that data it messes it up.

here on the board in the past there were times multiple searches took so much processing power that the board crashed.


I do know it's not about "getting a more powerful server"

At work I manage a database server that is not "huge" it has about 150GB of image data, but with a xeon processor, 3GB ram, and a gigabyte connection it still can take up to 20 seconds for some queries.


the software powering the board is another issue. if the software were to allow "cached" searches like "la7" "b29" or whatever maybe they could implement those, but I don't think the software has that capability.



now I could be completely wrong on this, but I do remember Skuzzy mentioning the database issues 1 time when the search character limit was pushed up to 4 characters.

Skuzzy if you could let me / them know if I am close to correct on this, thanks.
I don't know what to put here yet.

Offline clerick

  • Silver Member
  • ****
  • Posts: 1742
change in BBS Search function
« Reply #8 on: October 30, 2007, 08:05:35 PM »
Maybe that is the solution.  Have a select box with the plane types in it, you can choose from there.  It eliminates the idiots who would search for the letter "A" :p and allows a pre-cached search for what i assume is a very common topic.
« Last Edit: October 30, 2007, 08:08:15 PM by clerick »

Offline Meatwad

  • Plutonium Member
  • *******
  • Posts: 12896
change in BBS Search function
« Reply #9 on: October 30, 2007, 08:20:34 PM »
Yes!!!

Many a search came up under the minimum character length and make Meatwad very frustrated :cry
See Rule 19- Do not place sausage on pizza.
I am No-Sausage-On-Pizza-Wad.
Das Funkillah - I kill hangers, therefore I am a funkiller. Coming to a vulchfest near you.
You cant tie a loop around 400000 lbs of locomotive using a 2 foot rope - Drediock on fat women

Offline Latrobe

  • Persona Non Grata
  • Platinum Member
  • ******
  • Posts: 5975
change in BBS Search function
« Reply #10 on: October 30, 2007, 08:33:25 PM »
Quote
Originally posted by clerick
Maybe that is the solution.  Have a select box with the plane types in it, you can choose from there.  It eliminates the idiots who would search for the letter "A" :p and allows a pre-cached search for what i assume is a very common topic.


Hey, I may be completly stupid, nuts and/or crazy but I'm no idiot......I tink. :)

Offline clerick

  • Silver Member
  • ****
  • Posts: 1742
change in BBS Search function
« Reply #11 on: October 31, 2007, 09:06:06 PM »
well... you ARE a spit dweeb......  

:noid