Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
UBBDev.com
UBBWiki.com
Who's Online
3 registered (id242, SteveS, Mike L), 24 Guests and 16 Spiders online.
Key: Admin, Global Mod, Mod
Featured Member
Registered: 06/21/10
Posts: 58
Top Posters (30 Days)
Ruben 61
SD 53
Gizmo 48
gliderdad 33
Dunny 21
driv 18
dbremer 16
Mark S 13
Stan 13
Iann128 11
Latest Photos
Testing
Basildon Train Station
Basildon Town Centre looking from the rounderbout
Basildon Town Square
Gizzo Marx
Topic Options
#233893 - 01/18/10 07:27 AM Will there be any indexing engine incorporated in the future ?
smallufo Offline
enthusiast
Registered: 06/05/06
Posts: 263
Loc: Taiwan
Will there be any indexing engine incorporated in the future ?

Depending on SQL's 'like' is very time consuming and resource consumptive , especially there are millions of posts in the DB.
Incorporating 3rd party indexing engine , such as Lucene , can greatly simplify the search job.

Apache Lucene also has PHP bindings.


Edited by Gizmo (01/18/10 11:20 AM)
_________________________

English is not my native language.
I try my best to express my thought precisely.
I hope you understand what I mean.
If any misunderstanding results from culture gaps , I apologize first.
Top
Express Hosting
Express Hosting "We are the official hosting company of UBB.threads. Ask us about our free migration services to migrate your UBB.threads installation."
#233901 - 01/18/10 11:57 AM Re: Will there be any indexing engine incorporated in the future ? [Re: smallufo]
SD Online   partay
Registered: 04/19/07
Posts: 4031
Loc: SoCal, USA
i also would personally love to see ubb.T get away from full-text indexing that myISam offers..

but i'd bet that Lucene would have to be an option as not everyone can just ask their host to install it..

same would go for any other non php/mysql solution..
_________________________

Threads tutorials . Threads & Wordpress experts . UBB resume

If I you, click this link as to why
Top
#233910 - 01/18/10 04:02 PM Re: Will there be any indexing engine incorporated in the future ? [Re: SD]
smallufo Offline
enthusiast
Registered: 06/05/06
Posts: 263
Loc: Taiwan
If Lucene is a little hard , I'd suggest Apache Solr .

Apache Solar is a Lucene's Wrapper , it's like a daemon , which accepts HTTP's POST DATA , and make index of them.
In short , Lucene is programming/API level , while Solr is HTTP level , which accepts any language (just that language able to make HTTP Post).
_________________________

English is not my native language.
I try my best to express my thought precisely.
I hope you understand what I mean.
If any misunderstanding results from culture gaps , I apologize first.
Top
#233911 - 01/18/10 04:12 PM Re: Will there be any indexing engine incorporated in the future ? [Re: smallufo]
Philipp Offline
journeyman
Registered: 07/30/06
Posts: 82
Why not using Sphinx?
Top
#233913 - 01/18/10 04:19 PM Re: Will there be any indexing engine incorporated in the future ? [Re: Philipp]
Rick Offline
Post-a-holic
Registered: 06/04/06
Posts: 10164
Loc: Aberdeen, WA
We certainly can't just tie in to an external option by default because many people won't have access to it. However, we can certainly work on putting in some sort of options for it. Sphinx is one that I've been looking at pretty closely.
Top
#233914 - 01/18/10 04:47 PM Re: Will there be any indexing engine incorporated in the future ? [Re: Rick]
smallufo Offline
enthusiast
Registered: 06/05/06
Posts: 263
Loc: Taiwan
I think it can be made an "option"
If the indexing server is setup properly , it will start to grab old posts and indexing old/new posts.
If indexing engine is not set , it will fall back to MySQL's LIKE.
_________________________

English is not my native language.
I try my best to express my thought precisely.
I hope you understand what I mean.
If any misunderstanding results from culture gaps , I apologize first.
Top



Moderator:  AllenAyres, Ian, Ron M 
Shout Box

Today's Birthdays
No Birthdays
Recent Topics
Edit Post
by Bert
01:19 PM
A positive note
by SteveS
09:36 PM
How to locate links to particular site if they are only used in images?
by Conrad
02/10/12 09:41 PM
Pictures not displaying
by Marker23
02/09/12 10:04 PM
Issue with logging out constantly
by Flanuva
02/09/12 07:05 PM
Forum Stats
10213 Members
36 Forums
33667 Topics
180917 Posts

Max Online: 978 @ 06/24/07 11:19 PM
Random Image