View unanswered posts | View active topics It is currently Mon Apr 15, 2024 11:29 pm



Reply to topic  [ 10 posts ] 
 searching 
Author Message
Lieutenant Commander
User avatar

Joined: Sun Jan 29, 2006 3:00 am
Posts: 793
Location: Iowa
Unread post searching
Love the new look. Speed is incredible. I'm still having trouble searching the database. I can't seem to get a match to the simplest keywords...

_________________
#+++
The early bird may get the worm, but the second mouse gets the cheese.
#---


Wed Dec 19, 2007 7:05 am
Profile ICQ YIM
Site Admin
User avatar

Joined: Sun Dec 24, 2000 3:00 am
Posts: 1432
Location: USA
Unread post Re: searching
Crosby wrote:
Love the new look. Speed is incredible. I'm still having trouble searching the database. I can't seem to get a match to the simplest keywords...


Ok thanks I Will ask Eleq to look into it.


Wed Dec 19, 2007 7:54 am
Profile
Hall of Famer
User avatar

Joined: Wed Feb 28, 2001 3:00 am
Posts: 111
Location: USA
Unread post 
Give me an example, Crosby. A cursory look makes me think it's working.

_________________
EleqTriziT
thestardock.com


Thu Dec 20, 2007 4:09 pm
Profile ICQ WWW
Hall of Famer
User avatar

Joined: Wed Feb 28, 2001 3:00 am
Posts: 111
Location: USA
Unread post 
I finally found some problems with it. I'm not going to sweat it right now as phpbb3 is coming baring any weird problems.

_________________
EleqTriziT
thestardock.com


Thu Dec 20, 2007 6:47 pm
Profile ICQ WWW
Gameop
User avatar

Joined: Sun Sep 01, 2002 2:00 am
Posts: 215
Unread post 
The search feature is no biggie at the moment. The main thing is the data is still intact


Thu Dec 20, 2007 7:14 pm
Profile
Lieutenant Commander
User avatar

Joined: Sun Jan 29, 2006 3:00 am
Posts: 793
Location: Iowa
Unread post er, search terms
well, as examples I did a search for keywords: macro, plock, p-lock and got NO hits on my search. I'd like to think the search is pretty straightforward, are you getting hits on these?

I realize its not too big a deal, yet what good is all the data that was saved if you can't retrieve it when you need it? (animal) I mean, are ya just gonna sit and read every post when you're looking for something?

In days past it made for good reading on slow days to type in a keyword and see what past posts came up. Macro used to land me dozens..if not hundreds of posts. Please forgive if I'm searching incorrectly somehow...

_________________
#+++
The early bird may get the worm, but the second mouse gets the cheese.
#---


Thu Dec 20, 2007 7:25 pm
Profile ICQ YIM
Veteran Op
User avatar

Joined: Thu Jun 02, 2005 2:00 am
Posts: 5558
Location: USA
Unread post 
In phpBB search is done via keywords. When you post a message a KW index is built and posted to a separate table. Normally this isn't a problem, but when migrating databases it becomes a real chore. That table can get MASSIVE very quickly, I've had 100+ mb phpBB databases where 90mb was nothing but the KW table.

There are some plugins available, I forget the names offhand, that can rebuild this table. It takes a very long time, but you can look into doing it. Worst-case scenerio you could mod the plugin to rebuild this in phases, I had to do something like that for a client project a while back.

I do not know if phpBB 3 will do away with this table. If it does, that would be a very welcomed change. If not, then phpBB 3 will not fix the search problem.

_________________
May the unholy fires of corbomite ignite deep within the depths of your soul...

1. TWGS server @ twgs.navhaz.com
2. The NavHaz Junction - Tradewars 2002 Scripts, Resources and Downloads
3. Open IRC chat @ irc.freenode.net:6667 #twchan
4. Parrothead wrote: Jesus wouldn't Subspace Crawl.

*** SG memorial donations via paypal to: dpocky68@booinc.com
Image


Thu Dec 20, 2007 10:39 pm
Profile ICQ WWW
Hall of Famer
User avatar

Joined: Wed Feb 28, 2001 3:00 am
Posts: 111
Location: USA
Unread post 
phpbb3 uses a different format for its search table, and has built-in options to rebuild it as it doesn't import the previous table during conversion. So the process of the upgrade is what will fix it.

_________________
EleqTriziT
thestardock.com


Thu Dec 20, 2007 10:43 pm
Profile ICQ WWW
Veteran Op
User avatar

Joined: Thu Jun 02, 2005 2:00 am
Posts: 5558
Location: USA
Unread post 
Sweet. Good luck.

_________________
May the unholy fires of corbomite ignite deep within the depths of your soul...

1. TWGS server @ twgs.navhaz.com
2. The NavHaz Junction - Tradewars 2002 Scripts, Resources and Downloads
3. Open IRC chat @ irc.freenode.net:6667 #twchan
4. Parrothead wrote: Jesus wouldn't Subspace Crawl.

*** SG memorial donations via paypal to: dpocky68@booinc.com
Image


Fri Dec 21, 2007 12:06 am
Profile ICQ WWW
Hall of Famer
User avatar

Joined: Wed Feb 28, 2001 3:00 am
Posts: 111
Location: USA
Unread post Re: searching
fixed

_________________
EleqTriziT
thestardock.com


Wed Dec 26, 2007 5:12 am
Profile ICQ WWW
Display posts from previous:  Sort by  
Reply to topic   [ 10 posts ] 

Who is online

Users browsing this forum: No registered users and 3 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group.
Designed by STSoftware.