Searct h Topic Title?

Any problems, requests or comments regarding the site can go in here.

Searct h Topic Title?

Postby Jynks on Sun Apr 22, 2007 2:10 am

Would be awsome if you have to the time to install the search topic title only function into the search...


Thanks
<---------- Top 20 Scifi Captians -------->
1: Capt. Malcolm 'Mal' Reynolds 2: Captian Kirk 3: Capt. Matthew Gideon 4: Han Solo 5: Capt. Janeway 6: Admiral William Adama 7: Capt Jean-Luc Picard 8: Dr. Hans Reinhardt 9 Freeman Lowell 10 Zaphod Beeblebrox 11 Capt. Dallas 12 Cpatian Sheredon 13 David Bowmen 14 Admiral Ackbar 15 Capt Begimum Sisko 16 Turanga Leela 17 Capt. McCrea 18 Susumu Kodai 19 Flash Gorden 20 Commander J. J. Adams And the Wrost Capt. Carmen Ibanez
User avatar
Jynks
Modding the Machine
 
Posts: 1857
Joined: Mon Apr 19, 2004 8:16 am

Postby MyK on Sun Apr 22, 2007 6:59 am

Doesn't Search Site form work like that :?
"The products suck! There's no sex in them anymore!" (Steve Jobs)
User avatar
MyK
The Ninth Passenger
 
Posts: 1064
Joined: Thu Nov 09, 2006 5:40 pm
Location: Tranquility Base

Postby spudthedestroyer on Sun Apr 22, 2007 4:03 pm

MyK wrote:Doesn't Search Site form work like that :?


Yes it does, it searches topic titles in the movie sections only. It does not search message body text :)
ImageImage
ImageImage
User avatar
spudthedestroyer
Rear Admiral Lieutenant General
 
Posts: 4398
Joined: Sat Apr 17, 2004 8:47 pm
Location: Royal Britannia

Postby MyK on Sun Apr 22, 2007 5:22 pm

Cool, so you already have the code and would only need to slightly modify it to make it work as an option in the main search form then ;) Cuz as I get Jynks' idea it would be useful if we were able to search only within topic titles and with all the extra options in the main search form IMO. Like say I'd like to search for "Guess the movie" thread and I know it's somewhere in the main section only forgot where exactly.

I've also noticed it takes quite some server time to locate last posts within long threads (like "Last movie you saw"). You're not doing page by page jumps or "do while" loop, are you? Cuz even though I'm not all that familiar with MySQL (I'm guessing that's what this site is on:?) most DBs have either JumpTo or JumpBy (or both) and you could calculate how far it should jump with page number or post number as a parameter. Just a thought.... Cheers!
"The products suck! There's no sex in them anymore!" (Steve Jobs)
User avatar
MyK
The Ninth Passenger
 
Posts: 1064
Joined: Thu Nov 09, 2006 5:40 pm
Location: Tranquility Base

Postby spudthedestroyer on Sun Apr 22, 2007 6:39 pm

The problem with server speed is this:
http://www.dead-donkey.com/modules/news ... php?id=211

I've been trying to get our host to move us to a better box for weeks now, but i get the feeling either the guy who's supposed to do it is on holiday or he's busy. The speed issue is server imo, not software.

BTW, I don't write the board code :wacky:
www.phpbb.com

I modify it heavily, the frontpage is all mine, the header, etc. but the board and the way it displays topics/forums/posts, etc aren't mine. Most optimisations they have already done.

You're not doing page by page jumps or "do while" loop, are you? Cuz even though I'm not all that familiar with MySQL (I'm guessing that's what this site is on:?) most DBs have either JumpTo or JumpBy (or both) and you could calculate how far it should jump with page number or post number as a parameter. Just a thought.... Cheers!


Are you up on modern SQL servers? They do all the optimisation in atomic steps at a lower level, so your sql can be written a million ways, but the optimiser always executes it in the quickest possible way. You may be really crap at SQL but the SQL server saves you and actually translates it into the best form before actually commiting. There's times it will be slower, which are patched as the mysql server software gets better, but its generally 'fixed' on the fly for you :)

There's nothing like a while loop in mysql, that's programmatical.

I believe the query for threads uses a LIMIT BY from, to, to restrict results
ImageImage
ImageImage
User avatar
spudthedestroyer
Rear Admiral Lieutenant General
 
Posts: 4398
Joined: Sat Apr 17, 2004 8:47 pm
Location: Royal Britannia

Postby MyK on Sun Apr 22, 2007 8:05 pm

There's nothing like a while loop in mysql, that's programmatical.


Yup, I was thinking of PHP code, not SQL/QBE ;)

LIMIT BY sounds like a client side range filter and not DB side :? That could be a problem with large datasets as it can clog systems memory. Don't know though, it might also be index based DB side filter like RANGE or something :?

I'm not strong with MySQL as I mostly work on larger DBs with Oracle, SQL Server, Apollo,... so I'm afraid I can't be of much help on this. It was just a though anyway ;)
"The products suck! There's no sex in them anymore!" (Steve Jobs)
User avatar
MyK
The Ninth Passenger
 
Posts: 1064
Joined: Thu Nov 09, 2006 5:40 pm
Location: Tranquility Base

Postby spudthedestroyer on Sun Apr 22, 2007 8:18 pm

limit is a server implementation. It will only retrieve subsets of the data, which you then loop through.
ImageImage
ImageImage
User avatar
spudthedestroyer
Rear Admiral Lieutenant General
 
Posts: 4398
Joined: Sat Apr 17, 2004 8:47 pm
Location: Royal Britannia

Postby Jynks on Mon Apr 23, 2007 8:49 am

There are hacks you could try out?

Search Topic Title Only Hack
http://www.phpbbhacks.com/download/859
<---------- Top 20 Scifi Captians -------->
1: Capt. Malcolm 'Mal' Reynolds 2: Captian Kirk 3: Capt. Matthew Gideon 4: Han Solo 5: Capt. Janeway 6: Admiral William Adama 7: Capt Jean-Luc Picard 8: Dr. Hans Reinhardt 9 Freeman Lowell 10 Zaphod Beeblebrox 11 Capt. Dallas 12 Cpatian Sheredon 13 David Bowmen 14 Admiral Ackbar 15 Capt Begimum Sisko 16 Turanga Leela 17 Capt. McCrea 18 Susumu Kodai 19 Flash Gorden 20 Commander J. J. Adams And the Wrost Capt. Carmen Ibanez
User avatar
Jynks
Modding the Machine
 
Posts: 1857
Joined: Mon Apr 19, 2004 8:16 am

Postby spudthedestroyer on Mon Apr 23, 2007 10:12 pm

that site has a bad security rep, a lot of those hacks are very old and exploitable :(

Is the frontpage search not up to snuff or are you needing it beyond movies?

http://www.dead-donkey.com/search.php
ImageImage
ImageImage
User avatar
spudthedestroyer
Rear Admiral Lieutenant General
 
Posts: 4398
Joined: Sat Apr 17, 2004 8:47 pm
Location: Royal Britannia


Return to Site Help & Development

Who is online

Users browsing this forum: No registered users and 8 guests